I'm using VLOOKUP to look up a value on another worksheet. The lookup works
fine when I use a constant for the sheet name but I get 'The Formula You
Typed Contains an Error' message when I try to pull the sheet name from a
cell on the current worksheet.

Is there an easy way to arrange a formula that will Sum all integers
of a given number?
such that when applied on colum A, the result will be B:
21                    3

There is a workbook with a sheet for every month (Jan - Dec)  Is there a way
to reference a sheet based on a variable that a user defines?  
For example:
I have a summary sheet named 'Summary'; in cell 'Summary'!A1  I have a drop

I'd like to try and automate converting numbers (ex 2035.92) int the text
equivalent
"Two Thousand Thirty Five, and 92/100"
Similar to how you "spell" a number on a bank check.

Got a list of customers.
Can identify duplicates by address
I only want to keep the highest value customer at each address:
e.g.

  Can someone help me to know how to locate the current active cell using
color banding highlight the row and column (like a cross-wire)

Hello, I have a list with values,
I want to create validation list for each cell [B] depending on value in cel
[A]
       [A]     [B]                                        [D]    [E]    [F]

I have a 7 tiered sales volume grid and the commission paid per thousand
changes at each tier.  EG:
0 - 1.5M           $3.00 per K
1.6 - 2.5 M        $4.00 per K

I have a worksheet in which I transfer stock from sheet to sheet.To
create a new sheet I simply copy the last one and change date.
My formula is f/example c2 of the current =f2 of the one before. How can
I copy this directly without having to update each time.

I have a complete product list with all the product numbers in Colum A, and
the quantities in Colum B.
On a separate sheet I have a smaller table which I would like to populate
with the products that have a quantity value next to them only.

I have a legacy Mac Excel spreadsheet that I converted to Windows years ago.  
I am now using Excel 2003, if that matters.  I understand the 1904 and 1900
date formats--both supported by Windows and I know how to change back & forth
between the two using Tools/Options/Calculations ...

Following a dialogue with Microsoft re the problem with the Discussion
groups, I received the following from Microsoft:
"Hello,
We have investigated the issue and we have discovered a bug which has been

Hi!
I recently upgraded from Office 2000 to Office 2003. I just discovered a
problem in freezing rows in Excel in 2003. I never had a problem with this in
2000.

I am trying to set up a function that will check the following
I am using Excel XP Pro
I have a date in cell F9.  It places a date in F1 that will be 7 days
earlier. (This works fine)

Is there a function that will spread a value across other values based
on that value. Example below :
Original Value
Week1 100