Value of cell in link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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".
 
=INDIRECT("'[YTD Unit Recovery Totals "& A1 &".xls]Internal'!$B$112")
with both books open
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded lookup 3
Build a reference to another worksheet from cell values in currentsheet 3
Sum with 3 conditions 9
Auto fill of formula 7
ytd totals for multiple years 2
Scrabble Value calculation for Welsh words 0
Sum Number of Rows based on Value in Another Cell 2
formula to add year to date figures 3

Back
Top