#1
|
|||
|
|||
Split workbook into worksheets
Hi,
I have got an Excel workbook with a few sheets in. I would like to split the workbook so that each separate sheet is transferred to a new workbook using VBA (in other words, split a workbook into many workbooks) and I would like to be able to choose where to save the new workbooks when the macro is running (meaning, open the save as dialogue). Please advise me what to do. Many thanks. |
#2
|
|||
|
|||
Link 1: https://www.excelforum.com/excel-pro...ml#post4788850
Link2: https://www.mrexcel.com/forum/excel-...orksheets.html |
#3
|
|||
|
|||
Quote:
Apparently not what you want. Care to post in this forum exactly what it is you do want and what typical sheet names would be ? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet | safrac | Excel | 17 | 10-04-2022 12:21 PM |
How do I populate Worksheets using information entirely from another Worksheet in the same Workbook? | BrieDanielle | Excel | 1 | 06-18-2016 10:50 AM |
Add worksheets to workbook | boboles | Excel | 2 | 01-26-2015 07:42 AM |
I need an index file containing the names of all the worksheets in a workbook. | retiredstuart | Excel | 3 | 09-12-2014 06:26 AM |
split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25) | gsrikanth | Excel Programming | 1 | 03-22-2012 11:04 PM |