automatically put date and time on the cells when saving ?
 

Hi i'm having to update the date and time on the changes on all the cells
when i change them and i do a lot of them all the time, change tracking gives
me this info on the left side pointers and wants me to take the new value or
some thing but i need the old value too, i just need it to keep adding info
with the date and time

automatically put date and time on the cells when saving ?
 

Hi Vivek,

Excel 2007, from the help menu:

You can View the history worksheet by going to the Review tab, in the
Changes group, click Track Changes, and then click Highlight Changes.

Under Highlight which changes, select the When check box and then, in the
When list, click All.
Clear the Who and Where check boxes.
Select the List changes on a new sheet check box.
Click OK.


Hope this helps.

PShepard


"Vivek" wrote:

Hi i'm having to update the date and time on the changes on all the cells
when i change them and i do a lot of them all the time, change tracking gives
me this info on the left side pointers and wants me to take the new value or
some thing but i need the old value too, i just need it to keep adding info
with the date and time