On Friday 27 November 2009, Andreas Saeger wrote: > 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 > No good! I want to be able to open the spreadsheet and see when it was last modified - NOW() gets updated when you load a SS, otherwise it would be the answer. Thanks anyway!
Bill -- +---------------------------------------+ | Bill Purvis, Model Engineer | | email: [email protected] | +---------------------------------------+ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
