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

  • Thread starter Thread starter accessman2
  • Start date Start date
A

accessman2

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.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data from workbook 2 to workbook 3 mystery! 2
STOP close button on another workbook 6
Copy Sheet to New File Without Code 5
Workbook Variables 2
Transfer data from one workbook to another workbook based on a key 2
Need to Keeping Same Display Value on 2 Workbooks 1
copy range using last active cell reference from 1 wkb to another 1
Vlookup or Match VBA 6

Back
Top