The Vlookup I created is returning the correct value for the first
record, but when I copy the lookup down the rest of the column, it
simply copies the value returned for the first record.  What's up with
this? I've done a lot of lookups and it hasn't done this before.  My

I have a spreadsheet, which tracks inventory on "sheet1" it has columns such
as "model" and "serial number" for example.  On "Sheet2" I would like to be
able to create a drop down menu that lets me select one of the entries from
the "model" column on "sheet1".  This I seem to ...

I am a novice to Excel VBA and would like to be pointed in the right
direction to solving the problem I am having with the code below.  I want to
use the For...Next i Loop for each Worksheet in my Workbook.  For some reason
the For Each...Next sh Loop is not working for the ...

I have a workbook that has 7 worksheets.  The worksheets are filled with lots
of formulas.  I want to be able to stop anyone from changing or altering the
formula, on purpose or by mistake.  Is there away to do this and still allow
for data entry?  Or do I need to lock the ...

When calculating the avg of numbers in say a dozen consecutive cells, what
does the AVG function do if a cell is blank? or text? If it's a zero, I'm
sure it would be figured in, but if it's blank or text, would it calculate
the average based on 11 cells instead of 12? Hopefully ...

Hello, I have created a data query in Excel using DATA - IMPORT EXTERNAL DATA
- NEW DATABASE QUERY and then selecting Access and browsing to an query
within an Access database.  This query returns all data into excel, but I
would like to limit the criteria based on what a user ...

I have a spreadsheet with thousands of records.  One column contains
hyperlinks either created manually using the Insert->Hyperlink action
or via a =HYPERLINK() dynamic formula.
I need to return the URL for the cyperlink column into another column

I'm using the US version of Excel 2003, but need to format costs, etc., for a
project in the French euro format (e.g., I need 2050.45 euros to display as 2
050,45).
That currency format isn't offered in my dialog box, and if I make a custom

Please, i need help with a macro to order 2 columns like that:
Column A       Column B
     A                   A
     B                   B

i have two columns
col a       col b
q3          2/2/07
q2          10/12/06

Is there a switch to turn on the old colors in 2007? I hate the pastel
shades and don't want to hand map the entire theme. Please let me know.
RD

I've noticed a few threads related to the topic of preservingi table
formats after a refresh, but after trying all the suggestions (along
with Contexture's tip on the issue), many of my tables still loose
their formatting after the table is refreshed.  Simple formatting too

I have now moved to Excel 2007. One function I use a lot is cutting a row and
inserting it in another location. Previously I highlighted the row and cut,
this would not only take the contents into the buffer but also delete the
row. I would then highlight a new row and select ...

Is there any way that you can count the number of textboxes and other
drawing objects in a sheet using c# or VB from an application and change
their contents?

If I'm adding say 4 cells, and one cell has text in it, is there a way to
disregard the text and get the numeric total? I get a #value! error now. I
can't ignore the cell because sometimes there are numbers in it. I could use
shading, but I really need a text designator in the ...