Importing named range from another workbook

[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.

 

[GS]

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.

Try a cell formula...

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

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

 

[kittronald]

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.

 

[Gord Dibben]

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

 

[GS]

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

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.

 

[Jarek Kujawa]

try to array-enter the formula i.e. with CTRL+SHIFT+ENTER

HIH