Creating separate files from multiple sheets

  • Thread starter Thread starter Shuvro Basu
  • Start date Start date
S

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
 
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
 
Back
Top