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

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

=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

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" wrote
in message ...

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,
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.


--
BannerBrat
------------------------------------------------------------------------
BannerBrat's Profile: http://www.excelforum.com/member.php...fo&userid=5485
View this thread: http://www.excelforum.com/showthread...hreadid=532712

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