=now()

[BannerBrat]

Hoping someone can help
I'm trying to come up with a macro that if a3 is populated it would return the date and time it was done in b3, then if a4 is populated it would do the same in b4, so on and so forth. The formula I came up with updates everything in column b

[Toppers]

What's your formula?

"BannerBrat" wrote:

>
> Hoping someone can help
> I'm trying to come up with a macro that if a3 is populated it would
> return the date and time it was done in b3, then if a4 is populated it
> would do the same in b4, so on and so forth. The formula I came up
> with updates everything in column b
>
>
> --
> BannerBrat
> ------------------------------------------------------------------------
> BannerBrat's Profile: http://www.excelforum.com/member.php...fo&userid=5485
> View this thread: http://www.excelforum.com/showthread...hreadid=532712
>
>

[Toppers]

=if(A3<>"",now(),"") ?

"BannerBrat" wrote:

>
> Hoping someone can help
> I'm trying to come up with a macro that if a3 is populated it would
> return the date and time it was done in b3, then if a4 is populated it
> would do the same in b4, so on and so forth. The formula I came up
> with updates everything in column b
>
>
> --
> BannerBrat
> ------------------------------------------------------------------------
> BannerBrat's Profile: http://www.excelforum.com/member.php...fo&userid=5485
> View this thread: http://www.excelforum.com/showthread...hreadid=532712
>
>

[Paul B]

BannerBrat, Have a look here for information
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

"BannerBrat" <[email protected]> wrote
in message news:[email protected]...
>
> Hoping someone can help
> I'm trying to come up with a macro that if a3 is populated it would
> return the date and time it was done in b3, then if a4 is populated it
> would do the same in b4, so on and so forth. The formula I came up
> with updates everything in column b
>
>
> --
> BannerBrat
> ------------------------------------------------------------------------
> BannerBrat's Profile:
> http://www.excelforum.com/member.php...fo&userid=5485
> View this thread: http://www.excelforum.com/showthread...hreadid=532712
>

[BannerBrat]

Toppers,
That is the formula that I was using.
It works only once, if more information is added to the sheet the time changes for all of the fields (column B).
What I'm trying to do is to wand in when shipment order comes in A3 and have B3 indicate the day and time it was wanded in. Then wand in the next shipment in A4 and have B4 indicate the day and time without changing B3 and so forth.

[Toppers]

Hi,
Stupid me!

The JE McGimsey Worksheet events solution works fine so maybe adopt that.


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("A2:A10"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub

"BannerBrat" wrote:

>
> Hoping someone can help
> I'm trying to come up with a macro that if a3 is populated it would
> return the date and time it was done in b3, then if a4 is populated it
> would do the same in b4, so on and so forth. The formula I came up
> with updates everything in column b
>
>
> --
> BannerBrat
> ------------------------------------------------------------------------
> BannerBrat's Profile: http://www.excelforum.com/member.php...fo&userid=5485
> View this thread: http://www.excelforum.com/showthread...hreadid=532712
>
>