Can I consolidate a bunch of workbooks iinto one?

M

Musawwir Spiegel

Using Excel 2002, I have a bunch of workbooks that deal with related
topics. Within each there are a few worksheets.

I would like to consolidate all of the workbooks into one. However, I
can't see any way to do this.

Is there a way?

Musawwir Spiegel
[email protected]
 
B

Bill Kuunders

One way.
Open the main book and open the others using the normal menu <file><open>
Use <windows><arrange><cascade>
and drag each sheet into the main workbook. Just click and drag the tabs.You
may want to rename the sheets as you go.

If you have too many books, open them in blocks of 8 at a time.
 
Top