Create New Workbook Using Selected Sheets From Another Workbook

Hi Guys!

I'm trying to work out a macro that will use certain worksheets from a workbook, to produce another workbook.

Basically Workbook 1 (main) contains 8 worksheets.

I want a button that will:

• Create A New Workbook (Workbook 2)
• Insert Worksheets A, B & D from Workbook 1

I want another button that will:

• Create A New Workbook (Workbook 3)
• Insert Worksheets A, C & E from Workbook 1

Any help would me much appreciated!!

Thanks
Dave

still trying to work this out. really could do with some input, thanks

Originally Posted by sweep

Hi,

You can use

Please Login or Register  to view this content.

to create your new workbook

and

Please Login or Register  to view this content.

to copy your worksheets across

would anyone be kind enough to put this macro together for me in an example workbook with a few sheets and a command button. i'm struggling, thanks!