I want to create a reference to a cell in one worksheet in Excel 2002 that
references the same information even if I sort the referenced cell, add
columns or rows to the referenced worksheet, or filter the referenced
worksheet.  

I have a spread sheet that i would like to have row shading when o is entered
in a cellbut will revert back to unshaded when this figure is incresaed above
0, any suggestions.
Alan

I just went through a labourous procedure of transfering data from Notepad
into Excel (PDF documents had previously been converted to Notepad to extract
text).  I used the MID function to extract the specific number I needed from
all the extranious data from the copy/paste.  I ...

I have a range say A4:A200 in cell A3 is the date and in the range there is a
bunch of cells that have a 3 up to 7 character text that equate to a time,
event, who and where code. I need something that will take the code and put
that code in a oneliner

logo only prints out in black and white

Hi, My name is Chuck and I am trying to write a spreadsheet to be use
as a daily timesheet.
The way it is set is: c6 is Time In, d6 Time out for Lunch, e6 Time i
from lunch and f6 is Time Out.

From the cells B2 to B18 I have some values in USD.
In B19 the sum of B2 to B18 is there. ( for example $ 1250.85)
Now In the cell B21 I need the wording corresponding to the figure found in
B19 (Example: USD. One Thousand Two Hundred and Cents Eighty Five only)

All help you can give me, I will appreciate.
I have dated cosecutive information in a jounal, Dates, Concept, Do
No. Account Numbers, Figures,etc.  Then in another sheets, I have t
transfer that data to individual sheet for each account, as a Ledger.

I have a list of about 10000 emails. They contain some good email
and some bad emails. I have figured out the bad emails and have a lis
of about 4000 - 6000 emails. Now i need to delete the bad emails fro
that 10000 email list.

     I have seen a worksheet with macros, having a button named
"generate CSV file". What isthis CSV file & what it will do? How does
it work. Is there any option to generate log file in excel.
Thanks and Regards

I have an excel file that has about 300 sheets.
And every week, i will have a new excel file that has same proporties.
And i don't want to save sheets manually. Can i save all sheets in new
excel files?

Hi, guys,
I am trying to create a spreadsheet that can calculate my GPA. I have
column B be the number of credit and column C be the letter grade I can
enter from F to A+. Now, I want column D to be the grade point, which is

Please i need for my job to modify my PC program:
Sub ArchiviaDoc()
Dim DataDoc As Date
Dim I, Righe As Integer

Is there a formula that can calculate the difference between two hour/minute
entries, such as converting the time between 4:00 and 5:15 is 1:25.

Is there a function that will take a date (eg. 10/20/05) and yield the
corresponding day of the week?