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