Copy 7 sheets of data

magnum55

New Member
Joined
Nov 10, 2005
Messages
24
Hi All,

I have a workbook with 10 worksheets in test.xls. What Id like to do has 2 parts to it:

1) Create 3 new files from my 'ref' worksheet based on a names in say A1:A3 of sheet 'ref'
2) Within each file, I want to copy specific sheets from test.xls and entire contents. Some files require 2 sheets others require up to 4 sheets. These sheets are currently in use in test.xls, so essentially id like to copy the sheets into the workbook. Im happy to reference these in the 'ref' sheets as the sheet names wont change. ANy hepl would be greatly appreciated.

Workbook names (A1:A3 in the 'ref' sheet)
Apple.xls
Orange.xls
Plus.xls

Apple should contain the 3 sheets (copied from test.xls)
red
orange
green

Orange.xls should contain 4 sheets (copied from test.xls)
sour
juicy
pips
soft

Plum.xls should contain the 2 sheets (copied from test.xls
round
bruised

Many Thanks
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,203,453
Messages
6,055,530
Members
444,794
Latest member
HSAL

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