See if the INDIRECT function will help.
On Sat, 5 Mar 2005 01:48:58 +0800, "automne"
wrote:
Dear all,
Is is possible to use value store in other cells in external links?
Say I have a list of filename on column A
apple.xls
orange.xls
banana.xls
.... and thousands more.
How can I build external links to these workbooks by formula easily? Like
this for example,
='C:\apple.xls\Sheet1'!$A$4
='C:\orange.xls\Sheet1'!$A$4
='C:\banana.xls\Sheet1'!$A$4
Any help would be highly appreciated.
Thanks & regards,
Automne
|