Depends on what you mean...

You can copy the worksheets from each workbook into that third new workbook.

Just open workbooka and workbookb.
Select all the sheets in workbookb that you want to copy to workbooka.
Edit|Move or copy sheets
To book: Select workbookA
Check copy

Close workbookb
And inside workbookA, do a File|SaveAs and saveas a new name.

========
You could also just copy the contents of any one sheet and paste to the bottom
of any other sheet.

========
Or if you have a column that contains unique keys, you could use =vlookup() or
=index(match()) to retrieve values from one worksheet and place them into other
columns in another worksheet.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

omniplayer wrote:

Hey Guys,

here is my situation.

I have two workbooks (excel files) WorkbookA.xls and WorkbookB.xls. I
would like to combine them both into WorkbookTotalC.xls.

Is this possible? I am using Excel 2000. I also have access to Excel
2003.

Thanks in advance!

--
omniplayer
------------------------------------------------------------------------
omniplayer's Profile: http://www.excelforum.com/member.php...o&userid=30919
View this thread: http://www.excelforum.com/showthread...hreadid=505979

--

Dave Peterson