How to create a macro which performs a copy-and-paste task every 5mins after data is refreshed from

  • Thread starter ­»´ä®a©~¸Ë­×
  • Start date
­

­»´ä®a©~¸Ë­×

I have built a web query in my worksheet and the data are imported
every 5 minutes. I am trying to copy and paste the lastest data to the
far right column so that a time series can be made. However, I am not
sure how to create a macro that can be carried out repeatedly every 5
minutes and most importantly, the marco needs to be carried out after
the data is updated.

12:00 12:05 12:10 12:15 12:20 12:25 12:30

Type1 12.4% 12.6% 12.6% 12.4% 13.2% 13.9% 13.9%
Type2 6.8% 9.5% 18.2% 16.7% 15.8% 14.9% 13.9%
Type3 9.6% 6.8% 5.9% 5.1% 5.1% 4.8% 5.1%
Type4 3.9% 6.3% 5.9% 6.3% 6.8% 7.5% 8.2%
Type5 37.3% 25.6% 21.0% 19.1% 17.8% 16.1% 15.5%
Type6 4.3% 4.6% 4.6% 5.1% 5.1% 5.5% 5.5%

Can anyone help me on this? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top