Timestamp in Cell A

[PhilB62]

I would like to create a timestamp in Cell A1 whenever anything is put in Cell G1. Then copy that down the sheet. B1, C1 etc..

I've tried =if(G1<>"",now(),"") but the date and time changes when ever anything else is added to the worksheet.

I've tried =IF(G1<>”",IF(A1=”",NOW(),A1),”") which I believe is 'circular referencing' but just keep getting "The formula you typed contains an error".

Can anybody help please. I'm a newbie so be gentle. Got a feeling its going to have to be a Macro, which I have never used before.

Thanks in advance.
Phil

[HaHoBe]

Hi, Phil,

Now() is a volatile function which gets refreshed whenever any formula in t he workbook is calculated (on automatic Calculation of course only). Maybe have a look at this sample workbook by Stephen Bullen or change to use VBA and the Worksheet_Change-event.

Ciao,
Holger