JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
Probably a simple answer to this but seem to be struggling thinking of!
I have a workbook with the following named worksheets:
Balance Sheet Filter
Original Data
Remaining
Filter1
Filter2
Static Data
The number of 'Filter' worksheets varies depending on the existing macro's output.
I wish to cut worksheets 'Filterx' and 'Remaining' into a new workbook but can't think how. Ideally, I want to build up a VBA line of code via a loop process as:
Which I would then cut and insert into a new workbook.
Any suggestions on how I can do this please?
Thanks,
Jack
Probably a simple answer to this but seem to be struggling thinking of!
I have a workbook with the following named worksheets:
Balance Sheet Filter
Original Data
Remaining
Filter1
Filter2
Static Data
The number of 'Filter' worksheets varies depending on the existing macro's output.
I wish to cut worksheets 'Filterx' and 'Remaining' into a new workbook but can't think how. Ideally, I want to build up a VBA line of code via a loop process as:
Rich (BB code):
Worksheets(Array("Remaining","Filter1","Filter2" etc)).Select
Which I would then cut and insert into a new workbook.
Any suggestions on how I can do this please?
Thanks,
Jack