| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink to sheet in formula, can't save under new filename
Hi,
I'm making a spreadsheet to be used widely, therefore need it to be foolproof, my problem is with the Hyperlink in the formula below, the filename is required to link to a sheet within, so anytime someone saves to a new filename, the links don't work. Any idea how to use a "wildcard" for filename and maybe even simplify this formula? =IF(VLOOKUP($A2,'Original data'!$A$2:$K$3029,6,FALSE)="Complete","Done",HYPE RLINK(CONCATENATE("Template.xls]",A2,"!B27"),IF(INDIRECT("'"&A2&"'"&"!$E$4")="Comp lete",INDIRECT("'"&A2&"'"&"!$D$4"),INDIRECT("'"&A2 &"'"&"!$E$4")))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save As from chart sheet | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| how do I copy info from one sheet to another via a formula? | Excel Worksheet Functions | |||
| vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
