| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Value of cell in link
=INDIRECT("'[YTD Unit Recovery Totals "& A1 &".xls]Internal'!$B$112")
with both books open -- Gary''s Student - gsnu200723 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
| Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions | |||
Hybrid Mode
