Advanced Links

Giganews Newsgroups
Subject: Advanced Links
Posted by:  Stuartf (Stuartf.27ylyn_1147882204.378@excelforum-nospam.com)
Date: Wed, 17 May 2006

Hi,

I need to display info from a different xls file using info from
current xls file to determine which xls the data info is from....

so far i have

="'\Alpha\Client
Serv\OfficeDocs\Invoices\[0"&MIDB(A7,2,5)&".xls]Invoice'!$E$47"

where A7=D12345

basically a7 is a job number and invoices are created as 012345.xls
(job number -D+0) and i want to display some info from this invoice in
a different xls file. Each row will be a different job thus a different
invoice filename.

Many thanks

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

Replies