Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Links
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...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=542973 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Links
You'd want to use the =indirect() function, but that only works when the
"sending" workbook is open. But Harlan Grove wrote a UDF called PULL that will retrieve the value from a closed workbook. You can find the function at Harlan's FTP site: ftp://members.aol.com/hrlngrv/ Look for pull.zip Laurent Longre has an addin (morefunc.xll) at: http://xcell05.free.fr/ That includes =indirect.ext() that may help you. Stuartf wrote: 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...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=542973 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Links
thanks m8 very helpful of u:) -- Stuartf ------------------------------------------------------------------------ Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535 View this thread: http://www.excelforum.com/showthread...hreadid=542973 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
options to update automatic links | Excel Worksheet Functions | |||
Prompt to update links | Links and Linking in Excel | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |