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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,056
Messages
5,835,158
Members
430,342
Latest member
Sailingexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top