Hi there, pretty simple request but having a difficult time using simple capture routine to do this properly.
1. I have several rows of live data streaming into my excel worksheet.
2. I want to capture the data every 1 minute and paste this data into another worksheet.
Can someone please provide the VBA code that will allow me to do this. I did notice another thread but this code isn't working for me:
Dim I As Integer
If I = 0 Then I = 1
Sheets("Sheet2").Cells(1, I) = Sheets("Sheet1").Range("A1")
I = I + 1
[login to view URL] Now + TimeValue("00:05:00"), "Capture"
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy