Different Date & Time stamps in different worksheets within same Excel 2010 workbook

[TheShyButterfly]

Hello all, I have just joined this forum because I have found the Danny Rocks videos on Youtube invaluable. I have looked high and low but haven’t been able to find a solution to this particular scenario anywhere on the Web. I thank you in advance for any assistance. Thanks to Bill Jelen I was successful in setting up the Date & Time stamp in the “Call Details” VBA worksheet – using his code below: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 4 Then Application.EnableEvents = False Cells(Target.Row, 2).Value = Date Cells(Target.Row, 3).Value = Time Application.EnableEvents = True End If End Sub The problem is when I logically assume that I can just create & modify this code for the “Supervisor sheet” it doesn’t work in the VBA code for the 'Supervisor sheet', but it ends up cancelling out the Date & Time stamp in the “Call Details” worksheet. I have a ‘Master Log’ worksheet where I have linked the cells in to the appropriate cells in the “Call Details” worksheet and to the “Supervisor sheet” worksheet (consolidating the information from the two worksheets into the Master Log worksheet. How do I get the 2 different Date & Time stamps to work in both worksheets? I need the following: 1. Date & Time stamp the “Call Details” worksheet when data is entered into column 4, in the target cells row 2 (date), and cell row 3 (Time) (which is currently working fine). 2. When the supervisor enters in his name in CF2 (Column 84), in the “Supervisor Sheet” , I need the Date Stamp to go into cell CD2 (column 81) and Time stamp to go into CE2 (Column 82), keeping the original “call details” date & time stamp unchanged. Of course whenever the supervisor enters his name in this column it should update the cell in the row he is updating (from Cell CF2 to CF####). I really appreciate any assistance the you may be able to offer me ..... If you need more clarificaion, don't hesitate to ask ... I am using Windows XP, Excel 2010. *********************************************************************** Just an aside ... I have noticed that if I use the ActiveX Button it kills the date stamp function. I have worked around this by using the 'Form Button' and hyperlinking it to the sheet/cell. Maybe there is some VBA code that I need to stop the ActiveX Button interferring with the date stamp code ??? ************************************************************************ Kind regards

 

[TheShyButterfly]

Sorry about the 'blob' layout ... it's not how it looked when I entered it.

I'll try again with spacing so it makes it easier to read, hopefully it retains the setout.

Hello all,
I have just joined this forum because I have found the Danny Rocks videos on Youtube invaluable.
I have looked high and low but haven’t been able to find a solution to this particular scenario anywhere on the Web. I thank you in advance for any assistance.

Thanks to Bill Jelen I was successful in setting up the Date & Time stamp in the “Call Details” VBA worksheet – using his code below:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 4 Then
Application.EnableEvents = False
Cells(Target.Row, 2).Value = Date
Cells(Target.Row, 3).Value = Time
Application.EnableEvents = True
End If
End Sub

The problem is when I logically assume that I can just create & modify this code for the “Supervisor sheet” it doesn’t work in the VBA code for the 'Supervisor sheet', it ends up cancelling out the Date & Time stamp in the “Call Details” worksheet.

I have a ‘Master Log’ worksheet where I have linked the cells in to the appropriate cells in the “Call Details” worksheet and to the “Supervisor sheet” worksheet (consolidating the information from the two worksheets into the Master Log worksheet.

My question is .... How do I get the 2 different Date & Time stamps to work in both worksheets? I need the following:

1. Date & Time stamp the “Call Details” worksheet when data is entered into column 4, in the target cells row 2 (date), and cell row 3 (Time) (which is currently working fine).

2. When the supervisor enters in his name in CF2 (Column 84), in the “Supervisor Sheet” , I need the Date Stamp to go into cell CD2 (column 81) and Time stamp to go into CE2 (Column 82), keeping the original “call details” date & time stamp unchanged. Of course whenever the supervisor enters his name in this column it should update the cell in the row he is updating (from Cell CF2 to CF####).

I really appreciate any assistance the you may be able to offer me ..... If you need more clarificaion, don't hesitate to ask ... I am using Windows XP, Excel 2010.

*********************************************************************** Just an aside ... I have noticed that if I use the ActiveX Button it kills the date stamp function. I have worked around this by using the 'Form Button' and hyperlinking it to the sheet/cell. Maybe there is some VBA code that I need to stop the ActiveX Button interferring with the date stamp code ??? ************************************************************************ Kind regards