aproberts1980
New Member
- Joined
- Jul 14, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
I want to streamline a task for work colleagues I have a master excel sheet with 50 sheets in. Not all sheets are required each time a new copy of the spreadsheet is created. Is there a way to generate a menu within a front page on the spreadsheet where you could de-select the sheets that would not be required in the new copy and then using a macro remove the unwanted sheets from the newly generated spreadsheet. Even better would be the ability to carry out this same process in google sheets and have a script that would delete the sheets and generate a new copy of the google sheet within the a new folder destination.