Hello,
I'm currently trying to use this data logging script (below) developed by mrexcel members and it works great! However, I'm defining c to be about 15 and need it to loop such that the data shifts up one to maintain 15 data points AND on the last row add a new/current data point. I was thinking a loop vba to do this. Perhaps you guys have a better idea. Any help would greatly be appreciated... Thanks
I'm currently trying to use this data logging script (below) developed by mrexcel members and it works great! However, I'm defining c to be about 15 and need it to loop such that the data shifts up one to maintain 15 data points AND on the last row add a new/current data point. I was thinking a loop vba to do this. Perhaps you guys have a better idea. Any help would greatly be appreciated... Thanks
Code:
Private Sub Worksheet_Calculate()
c = Range("A" & Rows.Count).End(xlUp).Row 'Identifies last row in Column A with data
If c = 12 Then
Exit Sub
Else
Range("A" & c + 1).Value = Range("A1").Value
Range("B" & c + 1).Value = Range("B1").Value
End If
End Sub