K0st4din
Well-known Member
- Joined
- Feb 8, 2012
- Messages
- 501
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello friends,
I searched a lot on the internet and found countless similar solutions, but not exactly what I was looking for.
I ask for your assistance.
I have a workbook with 38 worksheets.
I made myself a UserForm1 in which I inserted 28 worksheets with their names.
These names are with CheckBox1 so I can choose which ones to copy to a new workbook and then a window pops up with a question: Give the title of the new file you want to save.
For example:
London and London total - I have to click (select) them and press the button in userform1 - Save selected sheets.
And that happens with all the other City and City total I choose.
It may be very easy, but I could not find a solution and help myself.
I ask for your help.
Thanks in advance
P.S. - Or, for example, make it automatically pick up all the worksheets and stack them with CheckBox
Link to sample file:
https://www.dropbox.com/s/94sgbrs99vhyqlf/SAVE IN NEW WORKBOOK.xlsm?dl=0
I searched a lot on the internet and found countless similar solutions, but not exactly what I was looking for.
I ask for your assistance.
I have a workbook with 38 worksheets.
I made myself a UserForm1 in which I inserted 28 worksheets with their names.
These names are with CheckBox1 so I can choose which ones to copy to a new workbook and then a window pops up with a question: Give the title of the new file you want to save.
For example:
London and London total - I have to click (select) them and press the button in userform1 - Save selected sheets.
And that happens with all the other City and City total I choose.
It may be very easy, but I could not find a solution and help myself.
I ask for your help.
Thanks in advance
P.S. - Or, for example, make it automatically pick up all the worksheets and stack them with CheckBox
Link to sample file:
https://www.dropbox.com/s/94sgbrs99vhyqlf/SAVE IN NEW WORKBOOK.xlsm?dl=0
Last edited: