I am using an excel file that I've placed on a shared server folder. I
created the original file, Three other people have access to the file. When
information is enter into the cells from two of the three they get an error
message "$names" in the formualted cells. But, if I open ...

Not sure if this is possible in Excel 2003.
I'd like to set up my screen to have multiple quadrants for seeing and
working on multiple worksheets.  Is this possible, and how?  Can Excel be
automatically configured to always launch in this mode, as opposed to a

I have a list of cells that contain client #'s in one sheet and another sheet
that has a bunch of data which I need to filter for each client #. (After it
is filtered, I'm copying that data into a new sheet, that part I have figured
out) What code can I use to look at a range of ...

How can I hide the formula in my excel sheet so the user cannot see or
modify the formula...

I would like to make a template that allows me to enter a date in to one
column and have the second column automatically calculate the date that
occurs 5 days later. If anyone can help me with setting this up I would
REALLY appreciate it.

I would like to be able to test a row in a matrix for a non-zero value.  When
I find the non-zero cell I want to return the value of column heading.

I can't merge any cells because this icon and menu option is disabled (grey).
how can i undo this, or does anybody knows why this has happend?

i want to put a drop down box in my worksheet but i am doing something very
wrong.
i want to put a yes and no in a drop down box with yes = 4 no = 0
then add what ever the number is in the next row then get the total in

I am trying to summarise data on 2 axes:
               Name:     John          Fred          Michael
Date:
01/01/00                  L

I have a spreadsheet that indicates the number of users for various products
from over 255 companies in rows. When I tried to create a pivot table and a
chart using those companies as row data I got a jumbled mess. I'd like to
filter the existing worksheet by the criteria of a ...

I have many worksheets that I need to combine into a master sheet. The data
in each sheet is different and the number of rows and columns are different
in each sheet and there are no headers or anything like that, just numbers is
each sheet.

I have a column of data in red font and a column of data in a blue font. I
then use concatenate to merge the a cell from each column into one. The
returned value however appear in black. How do I keep half in red and half in
blue?

is there a way that I can make this formula into
VBA code that looks up a given range see below
=RANK(A7,A$7:A$200)+COUNTIF(A$7:A7,A7)-1
and then used VBA the to get the Large and Small values

I have a worksheet that has 51 rows (one row per Soldier) including a
header row.  The columns contain different variables which will
determine whether each Soldier is eligible for promotion.  EX: did
Soldier qualify with primary weapon, pas the APFT, meet height/weight

Thanks for any help.
Typically I'll copy something 10 to 20 times, and just have to change one
word in the cell (like the month, from jan to feb to etc). And the remained
of the cell stays the same (like "balance" or whatever). The only way I know