Hi,
Can someone help me in getting a Macro Code for Data to be copied from one file to another on regular intervals
Setup:
1. I have a file which has a data connection, set up to refresh every 5 minutes
2. The final data is displayed in the form of a Pivot
Requirement:
1. Would want the Pivot data from the initial file to be copied to to another Excel file (Lets call it "Historical Data") every 2 or 3 hours
2. The Data needs to be populated every interval in the column next to the previous column.
eg:
1:00
aa
bb
cc
Next interval
1:00_______3:00
aa_________ ab
bb_________ ac
cc_________ ad
and so on...
Please let me know if I am not clear
Can someone help me in getting a Macro Code for Data to be copied from one file to another on regular intervals
Setup:
1. I have a file which has a data connection, set up to refresh every 5 minutes
2. The final data is displayed in the form of a Pivot
Requirement:
1. Would want the Pivot data from the initial file to be copied to to another Excel file (Lets call it "Historical Data") every 2 or 3 hours
2. The Data needs to be populated every interval in the column next to the previous column.
eg:
1:00
aa
bb
cc
Next interval
1:00_______3:00
aa_________ ab
bb_________ ac
cc_________ ad
and so on...
Please let me know if I am not clear
Last edited:
