| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | |||
| 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) | |||
| Create an external reference link with embedded variable | Excel Worksheet Functions | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
| Variable Link to Workbooks | Excel Worksheet Functions | |||
Threaded Mode
