Max & Don
Thanks for your assistance. I have opted for the variation provided by
Max as it worked first time.  Thanks again.
stm

I want to create an formula - where i type in a future date say July
5th 2005.
THEN to the right it will show me 21 days before 14 days before a week
before  and 4 days before BUT what i want to do is if that date is on a

I need to Find and Replace values in a Column
Same data also exists in other columns - so I would like to restrict the
Find and Replace to
a specified column

I have a basic spreadsheet for my work that keeps track of sales for a promo
that we have going on. I woulds like a formula that will tell me who is rank
1, 2, 3, 4,....so on. I have it so the final number in each category is a
percent and would like to have a ranking that ...

can someone help me i want to create a index sheet with all the
hyperlinks and hide the worksheets after that .When i click the
hyperlink the hidden worksheet should open and allow me to print the
sheet.

For example.
I have two files: p1.xls and p2.xls
In p1.xls in unknown Cells value = "AAA" or differend string.. and this file
isn't open.

I am trying to create a template for balancing reports .
The users will enter data and use the save as function so as to not save
over my template . A couple things I'd like to accomplish but being an excel
novice I'm unsure how and if it's possible .

I am working on a staffing worksheet and wish to highlight the rows for
the weekend. I have tried conditional formatting but I dont have the
know how to have just saturday and sunday rows coloured.
e.g.

i want to list all my cd's/albums alphabetically and by year. As my
collection grows is it possible to add to this list alphabetically and by
year. Or am i barking up the wrong tree, and should i use something else to
list my cd's with.

Before I go into reading all the help files.
Is it possible to read and update a
database file ( .mdb ) created with Visual Basic,
using a macro from within an Excel 97 worksheet.

Is there a way to make the default spreadsheet open with the "print
gridlines" box checked?
I've tried going to File->Page Setup->Sheet->Print gridlines, then doing
Save As, saving it as a template. But it doesn't "stick"

i AM WORKING ON A STAFF SCHEDULE. TIMES ARE ENTER BY A FORMULA. I WOULD LIKE
TO HIGHLIGHT CERTAIN FORMULAS TO COME UP IN A SPECIFC COLOR.

I want the first sheet to be a TOC of sorts with one column that is the
list of sheet names for the remaining sheets.

Apologies for the long subject line. I have a user who, when he opens
Excel, gets 2 instances of any file he has opened in Excel (including
Bool1.xls) in both the Applications page of Task Manager and the Start
bar, but only one Process (Excel.exe) in the Processes tab of Task

Hi all, I hope you can help an old dog learn a new trick here. I have a
list of 20 values for X, and thier matching Y values. Now, what I need
to do is find a way to get a formula so I can put in a different X and
get a Y.