Creating separate files from multiple sheets

[Shuvro Basu]

Hi All,

Ok. Here is what I have to do. Lets assume that I have 2 workbooks
BookA and BookB.. The BookA contains 20 sheets and BookB contains 3
sheets.

What I need to do is take each sheet from BookA and copy it as the
first sheet in BookB with the other 3 sheets coming after it in BookB

I tried some code but it didn't work more so because I got confused.

Any one willing to help will be highly appreciated.

Thanks and regards
Shuvro

 

[Pete_UK]

Open both workbooks and arrange each file window within the Excel
window so that you can see both - use Window | Arrange | Horizontal.

Then select Book A and drag the first worksheet tab into Book B and
position it as the first sheet. Use File | Save As to save the amended
Book B with a different name. Delete the worksheet from Book B, and
then repeat this process for the other 19 sheets in Book A.

When you drag the final worksheet from Book A its file window will
close, as you will have no more sheets left - Book A will not have been
changed, however, and will still contain the original 20 sheets.

Hope this helps.

Pete