Importing named range from another workbook

  • Thread starter Thread starter kittronald
  • Start date Start date
K

kittronald

Is it possible to import a named range from another workbook like
you would import a text file ?

In Workbook1.xlsb there is a named range called DATA that
references A1:C10.

I'm trying to import the data from that named range into
Workbook2.xlsb and keep that connection linked.

Any ideas ?



- Ronald K.
 
kittronald formulated on Friday :
Is it possible to import a named range from another workbook like
you would import a text file ?

In Workbook1.xlsb there is a named range called DATA that
references A1:C10.

I'm trying to import the data from that named range into
Workbook2.xlsb and keep that connection linked.

Any ideas ?



- Ronald K.
Click to expand...

Try a cell formula...

=Workbook1.xlsb!DATA
..if a workbook level name

=[Workbook1.xlsb]Sheet1!DATA
..if a sheet level name
 
Garry,

Thanks for the quick response.

I tried that, but it doesn't bring in the whole named range - just
the first cell.

If you can import a text file, why not a named range in an Excel
worksheet ?

When you import a text file, you get all the rows and columns from
the text file and can also fill down adjacent formulas in the
destination workbook.

Just haven't figured out how to import data from an Excel workbook.


- Ronald K.
 
In 2003

Data>Import External Data>Import Data

Files Of Type>Excel Files.

Drill down to the folder containing your workbook with the named range and click
OK

You will be presented with "Select Table"

Find your named range and OK

I believe quite similar in 2007 but not tested.


Gord Dibben MS Excel MVP
 
It happens that Gord Dibben formulated :
Data>Import External Data>Import Data

Files Of Type>Excel Files.

Drill down to the folder containing your workbook with the named range and
click
OK

You will be presented with "Select Table"

Find your named range and OK
Click to expand...

Thanks, Gord! Didn't know this because I've never 'Imported External
Data' from anything other than a database. For anything else I always
use ADO. -Didn't think that's the solution the OP wanted.
 
Back
Top