Combining Data from multiple workbooks
 

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

Combining Data from multiple workbooks
 

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

Combining Data from multiple workbooks
 

What I mean is I would like to keep WorkBookA and WorkBookB as is -
keeping all the data there. For example:

WorkBookA has a sheet called 2004 Sales with a total count of sales on
B12 and WorkBookB has a sheet called 2005 Sales with a total count of
sales on B12 as well.

Would WorkBookC (totally independent of the others) be able to get
information from WorkBookA and B? I have been able to get data from
other worksheets of the same workbook, but couldn't figure it out how
to do it with different workbooks.

Hope this clears it up a bit. Thanks again all!


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

Combining Data from multiple workbooks
 

If this is a one time thing, then manually copying and pasting the cells from
one worksheet to the other would seem like the easiest thing to do.

omniplayer wrote:

What I mean is I would like to keep WorkBookA and WorkBookB as is -
keeping all the data there. For example:

WorkBookA has a sheet called 2004 Sales with a total count of sales on
B12 and WorkBookB has a sheet called 2005 Sales with a total count of
sales on B12 as well.

Would WorkBookC (totally independent of the others) be able to get
information from WorkBookA and B? I have been able to get data from
other worksheets of the same workbook, but couldn't figure it out how
to do it with different workbooks.

Hope this clears it up a bit. Thanks again all!

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

Combining Data from multiple workbooks
 

If it was a one time thing, I would have done that already...any other
options?


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

Combining Data from multiple workbooks
 

Ron de Bruin has lots of sample code at his site:
http://www.rondebruin.nl

omniplayer wrote:

If it was a one time thing, I would have done that already...any other
options?

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