ExcelBanter - Value of cell in link

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Value of cell in link (https://www.excelbanter.com/excel-worksheet-functions/143895-value-cell-link.html)

StephanieH

Value of cell in link

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".

Gary''s Student

Value of cell in link

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

All times are GMT +1. The time now is 04:38 AM.