| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to add a variable as a parameter for a link?
Will it be possible to add a variable as a parameter for the link? as shown
below format, therefore, I can change its parameter based on certain cell value to link different spreadsheets? for example Original '[filename.xls]6220.HK'!$E$2 Modified approach '[filename.xls]C2.HK'!$E$2 , where C2 = 6220, which equals to linking '[filename.xls]6220.HK'!$E$2 Thank for any suggestion Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add a variable as a parameter for a link?
You have one response in .misc.
Eric wrote: Will it be possible to add a variable as a parameter for the link? as shown below format, therefore, I can change its parameter based on certain cell value to link different spreadsheets? for example Original '[filename.xls]6220.HK'!$E$2 Modified approach '[filename.xls]C2.HK'!$E$2 , where C2 = 6220, which equals to linking '[filename.xls]6220.HK'!$E$2 Thank for any suggestion Eric -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add a variable as a parameter for a link?
You can use INDIRECT
=INDIRECT("'[filename.xls]"&C2&".HK'!$E$2") note that the workbook needs to be open -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email) "Eric" wrote in message ... Will it be possible to add a variable as a parameter for the link? as shown below format, therefore, I can change its parameter based on certain cell value to link different spreadsheets? for example Original '[filename.xls]6220.HK'!$E$2 Modified approach '[filename.xls]C2.HK'!$E$2 , where C2 = 6220, which equals to linking '[filename.xls]6220.HK'!$E$2 Thank for any suggestion Eric |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add a variable as a parameter for a link?
Thank everyone very much
Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add a variable as a parameter for a link? | Excel Discussion (Misc queries) | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| How do I link to a workbook whose name is variable? | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
| Variable Link to Workbooks | Excel Worksheet Functions | |||
Linear Mode
