Functions accross files

[Daniel]

The project I am working on has a list of catalog number
to be watched on a regular time schedule. The data file
that has all of the information needed is a large file
with over 6000 entries. Is there a function that I can
use in the Excel speadsheet that will look at a second
speadsheet or any other type of file format and pull the
data needed and place it in the cell requested.

 

[hgrove]

Daniel wrote...

The project I am working on has a list of catalog number to be watche on a
regular time schedule. The data file that has all of the informatio needed is a
large file with over 6000 entries. Is there a function that I can us in the Excel
speadsheet that will look at a second speadsheet or any other type o file
format and pull the data needed and place it in the cell requested.

You can pull data from other Excel .xls files using external reference
in formulas such as

='C:\data\files\[myfile.xls]SomeWorksheet'!A5

or

=SUM('P:\shared\data\[ourfile.xls]OtherWorksheet'!B2:B101)

As for non-Excel files, if they could be accessed as database tables
you may be able to set them up as ODBC data sources and us
SQL.REQUEST

 

[Daniel]

Thanks I apprciate it. Would you be able to tell me a
manual or book that would explain the use of external
references?

-----Original Message-----

Daniel wrote...

The project I am working on has a list of catalog

number to be watched
on a

regular time schedule. The data file that has all of

the information
needed is a

large file with over 6000 entries. Is there a function

that I can use
in the Excel

speadsheet that will look at a second speadsheet or any

other type of
file

format and pull the data needed and place it in the

cell requested.

You can pull data from other Excel .xls files using external references
in formulas such as

='C:\data\files\[myfile.xls]SomeWorksheet'!A5

or

=SUM('P:\shared\data\[ourfile.xls]OtherWorksheet'! B2:B101)

As for non-Excel files, if they could be accessed as database tables,
you may be able to set them up as ODBC data sources and use

SQL.REQUEST.

---------------
hgrove's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=11432
View this thread: http://www.excelforum.com/showthread.php?threadid=261867

.