create:NOW() function

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?

redingto, have a look here for a way to do it

http://www.mcgimpsey.com/excel/timestamp.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"redingto" <redingto@discussions.microsoft.com> wrote in message
news:F4E16114-4387-46FA-B3FD-CE5D68AA153C@microsoft.com...
> 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?
>

You may find what you need in this page about timestamps:
http://www.mcgimpsey.com/excel/timestamp.html

Miguel.

"redingto" wrote:

> 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?
>

You need to use some VBA to do this, the following will work. Tweak the
Offset() function to get the right cells you like. The first input changes
the row, second changes the column.

Sub worksheet_change(ByVal target As Range)
ActiveCell.Offset(-1, 1) = Now() 'format as date
ActiveCell.Offset(-1, 2) = Now() 'format as time
End Sub

--
Regards,
Dave


"redingto" wrote:

> 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?
>