link to dynamic file name

realas

New Member
Joined
Oct 16, 2006
Messages
1
want to write link:
=[A7]Sheet1'!D2, where in cell A7 is 1_2_2006_10_19.xls it's a file name and i need to get data from 1_2_2006_10_19.xls file D2 cell. i can't write concrete link or file name ='[1_2_2006_10_19.xls]Sheet1'!D2, instead of [A7], because it will be changed next time. it will be, for example 4_5_2006.xls
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
You can change all the links to a particular file to be directed to another file in one go with Edit/Links/Change source command.

Otherwise you are going to need an add-in from Laurent Longre ( Morefunc.dll ) which includes the INDIRECT.EXT function ... see here:

http://xcell05.free.fr/english/
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top