How can I copy data from one workbook to my own workbook?

For example:

Workbook1:
File1: // this is the sheet name
File Num Date
1_______2/3/2005
2_______5/3/2005


sheet1:
Workbook2:
File Num Date
1_______2/3/2005
2_______5/3/2005


Thanks.


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

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

Another method:

With the source sheet active, turn on the macro recorder (Tools then Macro
then Record New Macro), right click the sheet tab. Select "Move or Copy",
check Create a Copy. Then set the "To book" drop down to "New Book".

Turn off the macro recorder and your code is done.

HTH

"accessman2" wrote:


How can I copy data from one workbook to my own workbook?

For example:

Workbook1:
File1: // this is the sheet name
File Num Date
1_______2/3/2005
2_______5/3/2005


sheet1:
Workbook2:
File Num Date
1_______2/3/2005
2_______5/3/2005


Thanks.


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