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)
Click to expand...

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.
 
Top