Value of cell in link

S

StephanieH

Is it possible to replace a portion of a link with the value in a cell?
For example, if A1 is "2007_03" and my link in G7 reads "='[YTD Unit
Recovery Totals 2007_03.xls]Internal '!$B$112", is it possible to replace the
"2007_03" the value of A1. What I'd like to do it type "2007_04" into A1 and
have the link change to "='[YTD Unit Recovery Totals 2007_04.xls]Internal
'!$B$112".
 
G

Gary''s Student

=INDIRECT("'[YTD Unit Recovery Totals "& A1 &".xls]Internal'!$B$112")
with both books open
 
Top