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
(e-mail address removed)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I prevent a blank email form being generated when I click in a cell that happens to contain a 2
Outlook 2007 - Accessing Email Properties re What Folder Message Is In 1
How to create a rule in which all email with a specific subject line causes message to have specific 4
Use a master workbook to carry over changes to multiple workbooks 1
Is there a way to get Word 2007 to automatically prompt the user to fill out a document summary when 3
Turning a row's contents into a column of entries 2
Why Do Keyboard Shortcut Assignments for Macros Disappear? 3
Open Workspace in Excel 2002 2

Top