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