Hey guys,
I posted a thread before but I figured out some of the stuff on my own and I am left with one more thing which I need to ask you guys.
I have two fields on my spreadsheet that update pretty much every second. I want to copy their values from one sheet into another and do this continously, but shift one row down every time it pastes data, so the old data stays on sheet2 whereas sheet1 keeps on updating.
To be more specific...
On the spreadsheet I have uploaded, I would like to copy cell G9 and H9 from Sheet1 to B2 and C2 of the sheet called "Chart". Once this happens I want the macro to copy G9 and H9 again and paste it into B3 and C3, and keep on shiffting down as it gets data from sheet1.
Also, it would be nice to have the macro do the copy pasting every 5sec.
Thank you very much for your help.