Finding worksheets based on master workbook worksheets and copying to master

bigwig88

New Member
Joined
Jun 27, 2014
Messages
3
Hi guys,

Apologies for my lack of VBA skills but I'm having difficulty finding code to do the below.

Basically I need a macro to copy and paste worksheets based on sheetnames from the master.

For example I have the following:

Master Spreadsheet with 5 worksheets named
A
B
C
D
E


I want to find worksheets A,B,C,D,E in a source worksbook which conatains hundreds of worksheets.

So I need the macro to loop through the source workbook find the worksheets named in the master and copy it into the master worksheet with the same name.

Thanks in advance for any help!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Hi,

Or even finding worksheet based on cell values and copying the sheet to a new master sheet? Does anyone have any ideas?

Thanks,
 
Upvote 0

Forum statistics

Threads
1,224,559
Messages
6,179,515
Members
452,921
Latest member
BBQKING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top