RSprengers
Board Regular
- Joined
- Nov 9, 2005
- Messages
- 54
I have an excel spreadsheet that updates automatically (DDE)
Every hour I want to copy 12 cells of data into a column so by the end of the day I will have 8 columns with each 12 cells showing me the data at different times of the day.
I've been reading about the OnTime method, but I really got lost...
Any help?
What I did so far:
I have the 12 cells updating through DDE (A1:A12)
I created columns C (08:00), D (09:00).... etc. until the end of the day
Can anyone please help me how to copy the data from column A into columns C and further at the times specified at the top of the column?
Thanks
Every hour I want to copy 12 cells of data into a column so by the end of the day I will have 8 columns with each 12 cells showing me the data at different times of the day.
I've been reading about the OnTime method, but I really got lost...
Any help?
What I did so far:
I have the 12 cells updating through DDE (A1:A12)
I created columns C (08:00), D (09:00).... etc. until the end of the day
Can anyone please help me how to copy the data from column A into columns C and further at the times specified at the top of the column?
Thanks