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