Help with OnTime to copy cell data

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
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

colbymack

Active Member
Joined
Jul 14, 2005
Messages
333
It sounds like you need to create a macro to execute your copy and pasting. You can then use the OnTime command within a separate macro that calls the other macro. You can also have that other macro (the one that does the copying) execute the OnTime macro at the end of the process to tee it up for the next hour's run.

HTH
Colbymack
 

colbymack

Active Member
Joined
Jul 14, 2005
Messages
333
Refer to a posting by Raver entitled:
"Run macro every 15 minutes from the top of the hour?"

It is similar to your request and should point you in the right direction hopefully.

colbymack
 

RSprengers

Board Regular
Joined
Nov 9, 2005
Messages
54
thanks, I will try to work this out.
I saw this post, but got confused....

(Newbe :oops: )
 

colbymack

Active Member
Joined
Jul 14, 2005
Messages
333
Let me know if you want help on this. I posted the solution for Raver as well.
 

RSprengers

Board Regular
Joined
Nov 9, 2005
Messages
54
I sorted it out..
using 2 macros (onTime and one to copy, and steering on onTime again)

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,118,330
Messages
5,571,570
Members
412,406
Latest member
DutchMonkey
Top