I'm trying to create an automated time-card file, where you enter your name
in one column and automatically the date is entered in a second column and
the current time is entered in a third column. So far, so good! (Yes, I can
get this to happen!). However, the problem arises with the NOW()
function..... whenever you enter a value for NOW() in any cell, it changes
the value of NOW() EVERYWHERE on the worksheet! So no matter when you enter
your name originally, the time listed will always be the time the last person
entered their name! Any idea how to correct this?
Bookmarks