»´ä®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.
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.