Copy a Range from different Workbook

  • Thread starter Thread starter DRS
  • Start date Start date
D

DRS

In workbook MASTER, worksheet FORM I need to copy in data
from a named range in workbook called DATA, worksheet
SHEET1. (DATA contains many ranges)

Example:
In FORM1 the user will enter the named range, RANGE101 in
cell A1
I now need all of the data in range RANGE101 to be copied
into FORM1 starting at A2

Any help is greatly appreciated.

DRS
 
Brad,

This is awesome.

I could not get it to find the the workbook "Data.xls"
but it did work for a range in workbook Master.
I tried having data.xls open, closed added the path, but
I just get "Subscript out of range" as it hangs looking
for Data.xls.

Both files are in the same folder.

c:\work\estimate\master.xls
c:\work\estimate\data.xls

Any idea as to why it does not find it?

DRS
 
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

How to reference a cell from anther workbook without opening it 0
Scattered array cells copy to scattered array cells another workbook 14
Copying cells and formula from closed workbook to all sheets in open workbook 0
Cell values to an array, then array transpose to another workbook 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy FROM - TO Object/Block variable not set 6
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Copy Multiple Areas from One Workbook to Another 4

Back
Top