Here is the application...I have a master worksheet that needs to pull
information from specific sells in several different files (excel worksheets)
in defferent directories. The filenames will change but the fields will be
the same. I have been using manual links and cut&paste to place the
information in the master worksheet. Is there a way to define a directory
path and filename is some cell within the master worksheet to use as a
reference for the linked cell to look so that it will automatically retrieve
the information without manual intervention?

hi,
=('C:\WOMonitor\FY03\[Jan.xls]MPX'!$A$4)
here is one i use to create a summery sheet from 12
monthly files.
you can use =sum and =count too.
=SUM(COUNTA('C:\WOMonitor\FY03\[Jan.xls]MPX'!$Z$4:$Z$500)-
COUNTA('C:\WOMonitor\FY03\[Jan.xls]MPX'!$AC$4:$AC$500))

-----Original Message-----
Here is the application...I have a master worksheet that
needs to pull
information from specific sells in several different
files (excel worksheets)
in defferent directories. The filenames will change but
the fields will be
the same. I have been using manual links and cut&paste
to place the
information in the master worksheet. Is there a way to
define a directory
path and filename is some cell within the master
worksheet to use as a
reference for the linked cell to look so that it will
automatically retrieve
the information without manual intervention?
.