Consolidating workbooks

jpross

New Member
Joined
Oct 15, 2002
Messages
36
I have a number of identical workbooks that I'd like to "pull" into a new workbook as separate sheets so that I may do some aggregation of data.

Is there an easy way to open a new workbook and "import" the workbooks into separate sheets within the new workbook?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Open the new workbook and insert as many new sheets as you will need. Then, open the first of the individual workbooks, click on the grey square on top of the row headers and to the left of the column headers. This highlights the entire worksheet. Copy to the clipboard and paste to sheet 1, cell A1 in your new workbook. Proceed the same way thru the rest of your workbooks. Should take only minutes.
 

BigC

Well-known Member
Joined
Aug 4, 2002
Messages
851
Stop!!
With all due respect to Barry, there is an easier & more beneficial way than the method suggested.
I'm assuming the workbooks you wish to copy from are single sheet workbooks, although it doesn't really matter as the technique would be very similar for multi-sheet workbooks.

Open the target workbook
Open the first source workbook
Point to the sheet tab of the source workbook and right click your mouse
Select "Move or copy .." from the context menu
In the "To Book" field, select the target workbook from the drop-down list
In the "Before Sheet" field, select where you want the new sheet to be located once it is in the target book
Click the "Create a copy" checkbox
Click Ok

The above will create an exact copy (an identical twin) of the source sheet (including page set up settings, formats, etc), and copy it into the target workbook in the location required.

HTH
 

Forum statistics

Threads
1,144,438
Messages
5,724,361
Members
422,546
Latest member
KevinOnTheDaily

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
Top