OMO Excel Help

[L3nny]

Hello fellow org geeks

I am creating a spreadsheet, it contains a list of tasks, when a task is complete the user enters their initials into a cell.

Is it possible for the cell in the next column to automatically insert the time the initial cell was updated

Cheers

[Sir Trev]

Yes.

=IF(I8="","",NOW())

I8 being the reference cell this will add a date/time value to the cell with this formula as soon a something other than nothing is added. Just tweak the format to show this in your prefered format.

Every time the reference cell is altered the date/time value will update to current time though. If that's a problem you will get into the fun area of cell protection.

[L3nny]

Sweet, thanks :D

[Davadvice]

Hi,

the time will update each time you open the spreadsheet to the current time.

i think you will need to do something with a MAcro that will check when the initial cell has changed then write the current time to the Cell you wish to update.

I'm Looking at this just now see it if can trap the cell change then pass to a Sub to write the time.

im out of here soon but will look again in the morning if noone else gets something beter.

cheers