Hello,

I'm fairly novice to excel. I've been looking for a solution to my problem and haven't been able to find anything specific enough (that I can recognize).

I'm trying to have column A populate with the current date and time (i.e. NOW) when data is entered in column B, then have that cell lock so the date and time cannot be manually changed and it will not update if the data in column B is changed.

Thank you in advance...