Do you want to 'copy' from or 'link' to the other workbook?

To copy from, simply open both files, Copy from one, activate the other
and paste.

To link to another file, use the formula:

='C:\Documents and Settings\My Documents\[Book.xls]Sheet1'!$A1

Click and drag this formula as needed to cover the desired range of the
file to pull from. This will change the data in your workbook whenever
the data is changed in the referenced file.

Of course adjust the file location and name to match your situation.

Good luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475871