Deliverable7
New Member
- Joined
- Apr 9, 2016
- Messages
- 33
Hi
I have a spreadsheet with 31 pages each containing daily input data and a messy range of calculations. I have modified the current spreadsheet to include complex data ranges (on a new tab) from which i pull up some graphs.
I now need to use this current spreadsheet as a template and to import data from previous months, each which is stored in separate spreadsheets. I have created a simple macro that can copy the input fields from one open tab on the new month file and paste into the corresponding tab on the template file.
So in summary I currently operate by:
'June.xls tab '1' open, Template.xls tab '1' open - execute the macro which copies the data ranges from June '1' to Template '1'.
I then open the respective tab '2's on each file and run the macro again, then for 3, then for 4 and so on.
I need to do this 31 times for each month (and probably need to convert 12 months of data).
Is there a way to run the macro once looping through until the input data from June '1' through to June '31' is copied across to the corresponding tabs on the Template file?
Thanks in anticipation.
I have a spreadsheet with 31 pages each containing daily input data and a messy range of calculations. I have modified the current spreadsheet to include complex data ranges (on a new tab) from which i pull up some graphs.
I now need to use this current spreadsheet as a template and to import data from previous months, each which is stored in separate spreadsheets. I have created a simple macro that can copy the input fields from one open tab on the new month file and paste into the corresponding tab on the template file.
So in summary I currently operate by:
'June.xls tab '1' open, Template.xls tab '1' open - execute the macro which copies the data ranges from June '1' to Template '1'.
I then open the respective tab '2's on each file and run the macro again, then for 3, then for 4 and so on.
I need to do this 31 times for each month (and probably need to convert 12 months of data).
Is there a way to run the macro once looping through until the input data from June '1' through to June '31' is copied across to the corresponding tabs on the Template file?
Thanks in anticipation.