Auto Display of Date

[emmieshane]

Hi Team,

Need some help. I'm currently working on this template but I can't seem to figure out what's going on with my formulas. I Need to add the current date and time on column Y when I enter "Received" or "Disputed" on column T. The problems are, when I use this formula: =IF(T2="",IF(Y2="",NOW(),Y2),"") Im getting "Circular Reference Warning". If I use this formula: =IF(T2<>"", IF(AB2="" ,NOW(), AB2), "") it's working but when I enter new information on the next row, the formula will be deleted. If I use formula: =IF(T2="","",NOW()) it also works but the acknowledgement date and time for each row would be the same date, every time you enter another information.

Please see the attachment.

Thanks!

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[emmieshane]

Hi Leo,

This is Amazing!

Sorry I'm a beginner. Can you tell me how you opened the VBA without putting in a password? I'm just trying to update this template and I wasn't able to ask for the macro password. Also, do I really need to add the formula in column AB? The formula actually shows when I get to row 7.

Thanks!
Emmieshane

[LeoTaxi]

you dont need formula just the code is fine


Kind regards
Leo

[emmieshane]

Hi Leo,

Thanks! I get it now.

This is highly appreciated!

Emmieshane