If cell A1 already contains a value don't update timestamp in B1

Hi all,

I have a problem I can't get my head around so I'm hoping you can help please?

I have a drop-down on each row in column A with a range of stages such as "Await Reply", "More Info Requested" etc.
I want column B to add a timestamp with Value = Now() when the first status is chosen in A, but I want B to ignore any further status updates to A (in order to always show the very first time a record is touched).

At present, the line of code I am using is
If ActiveCell.Value >= 0 Then ActiveCell.Offset(O,1).Value = Now()
however this populates column B the first time A is updated, but also every time the status changes thereafter...

Can someone please provide the code I need to achieve this please?

Many thanks,
Steve

change Now into Date

If ActiveCell.Value >= 0 Then ActiveCell.Offset(O,1).Value = Date

You can put a condition, stating that if activecell.offset(0,1) is not "", then dont update, else update.

try this

Please Login or Register  to view this content.