HappyChappy
Active Member
- Joined
- Jan 26, 2013
- Messages
- 378
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Hi dont know if its possible but i have a file that needs to have data sheets pasted into it. the data is held further down the file stucture which changes over time. for example main folder, year folder, month folder, week folder
inside the week folder is 7 spreasheets all dated for example debrief01.01.2020 to debrief07.01.2020 i need to open each one and copy the first sheet into my main folder spreadsheet. what i would like is a marco that prompts me for the file stucture by popping up a box to ask which year, then another which month, then which week. once i have told it where the files are to grab the data and paste them into the main spreadsheet.
Hope this makes sense. regards
inside the week folder is 7 spreasheets all dated for example debrief01.01.2020 to debrief07.01.2020 i need to open each one and copy the first sheet into my main folder spreadsheet. what i would like is a marco that prompts me for the file stucture by popping up a box to ask which year, then another which month, then which week. once i have told it where the files are to grab the data and paste them into the main spreadsheet.
Hope this makes sense. regards