Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a macro which performs a copy-and-paste task every 5mins after data is refreshed from web page?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Macro to Copy Data from one spreadsheet to another | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
I need formula help or create a macro to copy and paste value only | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions |