bill purvis wrote:
I am working on a multi-sheet parts list spreadsheet and it would be
really useful if I could automatically insert the date of the most
change at the bottom of each sheet. I can see that I can enter the
'current' date, but I'd really like the date at which any of the sheets
were last modified. At present I have a hidden field on sheet1 and
copy this to all the relevant cells, but then I have to unhide the
cell, update the content, and re-hide it each time I change something.
Is there such a function - I couldn't see it in the help list.
Bill
Type the address or name of the cell into the name box left of the
formula bar.
Then type into the formula bar: =NOW() F9 Enter Enter
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
