copy worksheets from a couple of workbooks to other workbooks

**masben** · 06-26-2014, 09:31 AM

Hi,

I have 25 files with certain worksheets that I need to move to 25 other files.

Worksheet 1, 2, 3 and 4 in Workbook A needs to be moved to Workbook A-2014
Worksheet 1, 2, 3 and 4 in Workbook B needs to be moved to Workbook B-2014
Worksheet 1, 2, 3 and 4 in Workbook C needs to be moved to Workbook C-2014
etc....

Is there a way to do this with a macro?
Preferably I would like to do this automaticly - i.e. runing the macro from a master file that

1. Opens Workbook A copies the worksheets
2. Open Workbook A-2014 paste the sheets
3. Save and close Workbook A-2014
4. Close workbook A without saving

then doing the same for Workbook B, etc.

Thanks!!
//Martin

**xladept** · 06-26-2014, 02:51 PM

Worksheet 1, 2, 3 and 4 in Workbook A needs to be moved to Workbook A-2014 Worksheets 1, 2, 3 and 4???

**masben** · 06-27-2014, 03:26 AM

Originally Posted by xladept

Worksheet 1, 2, 3 and 4 in Workbook A needs to be moved to Workbook A-2014 Worksheets 1, 2, 3 and 4???

Hi xladept,

Thanks for showing an intrest!

Little more detailed....

In Brasil.xlsm I have diffrent worksheets/tabs containg information on sale forcast, pipline customers, budget figures, regional directors comments, gross margins, etc...

For next years budget I have made up a new file Brazil 2015.xlsm

This file will contain a new forecast sheet but the rest should for now be exactley the same. The forecast sheet has already been set up in the new file Brazil 2015.xlsm and the other 4 sheets needs to be copied from Brazil.xlsm.

Except for Brazil there is 24 other files/countries that needs to be set up the same way...

Hope this makes it clearer - othervise just ask again..

Cheers,
Martin

**xladept** · 06-27-2014, 02:36 PM

Try this:

Please Login or Register  to view this content.

**masben** · 06-30-2014, 02:02 AM

Originally Posted by xladept

Try this:

Please Login or Register  to view this content.

Thanks Xladept!

This looks good - I'll think I can use it

Great!
//Martin

**xladept** · 06-30-2014, 02:56 PM

You're welcome and thanks for the rep!

copy worksheets from a couple of workbooks to other workbooks

LinkBack

Thread Tools

Rate This Thread

Display

copy worksheets from a couple of workbooks to other workbooks

Re: copy worksheets from a couple of workbooks to other workbooks

Re: copy worksheets from a couple of workbooks to other workbooks

Re: copy worksheets from a couple of workbooks to other workbooks

Re: copy worksheets from a couple of workbooks to other workbooks

Re: copy worksheets from a couple of workbooks to other workbooks

Thread Information

Users Browsing this Thread

Similar Threads

Copy selected worksheets between workbooks onto named worksheets

Copy/Paste Range of Data from Multiple Workbooks/Worksheets to Master Workbook/Worksheets

linking workbooks:couple days

A couple of strange things with macro workbooks

copy worksheets to new workbooks

Bookmarks

Bookmarks

Posting Permissions