Excel If Then Question - Part 2

[johnnycake23]

When I make an entry into A1, then B1 populates
with date/time stamp, which is what I want. However, when I make an
entry into A2, then B2 puts in a date/time stamp BUT it also changes
B1 to that date and time. How can I make it so that column B (and
subsequent columns) does not change with each new entry in column A?

 

[Dave Peterson]

If you use a formula that uses =now(), then this will reevaluate each time excel
recalcs.

You could use an event macro like the one at J.E. McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html

 

[johnnycake23]

If you use a formula that uses =now(), then this will reevaluate each time excel
recalcs.

You could use an event macro like the one at J.E. McGimpsey's site:http://www.mcgimpsey.com/excel/timestamp.html

Per the McGimpsey web page, I used the circular reference and this
worked for me. Thanks for pointing me there.

 

[Dave Peterson]

Be careful with those circular references. They can cause more harm than good.