Date of row change (auto entry date)

[reeedeeer]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Is there any way that column AA (or whatever column) can have a date appear according to the last time any value was created/changed in that row (say in all columns BEFORE column AA in that row)?

It used to be possible in Excel for PC (don't remember how I did it, but it might have also involved macro, although I think it was just a clever use of date() or now() ...

Ideas?

Thanks!

reeedeeer

 

[CyberTaz]

I don't believe there is any way to do this without VBA ‹ editing of a cell
is an event which the program doesn't track on the basis of when it occurs.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[reeedeeer]

Thanks Bob ...

... I remember using some tricks in the past where one used a circular reference in such a way that when certain cells would change that a function would be only recomputed then (and then one could use the date or now function to be recomputed). Anyone familiar with such subtle techniques and whether or not they work on Mac Word 2008?

Thanks!!!!

Reeedeeer