I want a given cell in a spreadsheet to return todays date if a value in a cell on the same row changes. How can I do this? Thanks

Hi Tom first off all I want to thank you very much for your response but unfortunately until now no success in my excel sheet which is very important to my...

The current record limit is 256 columns and 65kish rows, will this be extended in the 2003 version? I've heard that quattro pro looks at 1 million...

I want to add a figure in a cell to show how long I've spent on a job. In the adjacent cell I want Excel to add the new figure to the previous figure to give a...

I need a pivot table, that allows me to nest specific data filters within specific sets of data. For instance, if I pull down menu A, it gives me options 1,...

Is it possible to Concatenate two or more cells to create a formula? I.e. I would like to create a formula that references cells in a seperate workbook. Using...

Hi All, I have a list of thousands of names in which some of them are repeated twice or thrice. I want to get the list from that which would not have any...

I am running Excell 2000 Version 9.9.3821 SR-1 on my Millenium system. I want to have the number in a given cell recorded automatically in another cell, if...

OK, here goes: I have a sheet with values in column a, b, c and d, call the sheet "Projects" I have another sheet, call it, "Time", where in A1 I put a...

Take a look at ToolsAutocorrect. HTH Anders Silvén "FDDavis" skrev i...

I have this function and I want it to count all the cells in the specified range. =SUMPRODUCT(('Main FOB Log'!K3:K589"")*('Main FOB...

Is there a function similar to that of the WeekNum function found in excel 2002 for vba? And/or how do I call the function from excel, or a link to download a...

I'd like to use Excel to develop a project schedule. Is there a way to add, for example, 3 work days to a particular date? I know I can add 3 to any date and...

The following problems are not occurring in all of the cells with formulas even though the functions are exactly the same and referencing the correct cells. I...

I am doing a comparison of financial results. I have five columns which represent quarters. The financial results for each quarter are stored in different xls...

I want to highlight problems in a report. To this end I was planning to use the TEXT(text,format) function to allow me to change the color of the text. ...

I know it's easy, but I forget how. I imported a file from a data base to excel. The names came over combines, ie: (Sablone,Al A.) or (Sablone,AL) in one...

I created an excel macro, used it, and tried to delete it. however, every time I open the spreadsheet, it asked if I would like to "enable" or "disable" the...

I am using a spreadsheet set up by somebody else. It has several columns, where if you click on the radio button at the top, a data entry windows pops up and...

When I open up my file I am getting the 'Ready' message in the lower left hand corner but the screen is still gray and the file is not showing on the screen. ...