Hi,
I was hoping to create a a macro that would be able to open multiple spreadsheets and copy date in order to create a master spreadsheet.
The following is a setup of the folders and spreadsheets and tabs:
If I specify the file locations that I require data from multiple years and the file names.
Could a macro extract this data and label the year in a time series?
Would appreciate thoughts or ideas.
Please let me know if you require further infi
I was hoping to create a a macro that would be able to open multiple spreadsheets and copy date in order to create a master spreadsheet.
The following is a setup of the folders and spreadsheets and tabs:
1) I have data going from 1997 to 2021.
2) Each year has 20 tables folder.
3) Each 20 tables folders have almost 25 spreadsheets with almost 9 tabs.
4) In those tabs can I specify what columns needs to be copied in the master spreadsheet
If I specify the file locations that I require data from multiple years and the file names.
Could a macro extract this data and label the year in a time series?
Would appreciate thoughts or ideas.
Please let me know if you require further infi