Hello - I am trying to copy real time data in subsequent rows whenever the data gets updated. I am using the following VBA code. This updates irrespective of any change. I only want it to change when the time stamp in cell A2 is updated. Any suggestions on how can I update this code?
Private Sub Worksheet_Calculate() capturerow = 2 currow = Range("A65536").End(xlUp).Row Cells(currow + 1, 1) = Cells(capturerow, 1) Cells(currow + 1, 2) = Cells(capturerow, 2) End Sub
Cheers