merge 5 workbooks into 1 sheet

B

baron

I have 5 workbooks, each with at
least 3 worksheets.

In the end, I want 1 workbook
and 1 sheet.

(novice here, simple solutions only)

Thanks!
 
C

CyberTaz

Hi Baron -

With multiple workbook files open you can use Edit>Move or Copy Sheet to
combine the sheets into one file, but that only solves half of your plan...
It doesn't combine content from other sheets into a single sheet.

The easiest solution (though perhaps most time-consuming) is to simply copy
the content from one sheet then paste it where you want it on the "master
sheet" in the target file.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
J

JE McGimpsey

baron said:
I have 5 workbooks, each with at
least 3 worksheets.

In the end, I want 1 workbook
and 1 sheet.

(novice here, simple solutions only)

You really don't give enough information about what you're actually
trying to end up with (unless it's simply copying and pasting, which
Bob's post addresses).

You might want to take a look at the "About ways to consolidate data"
topic in XL Help.
 

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

Top