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")))) |
All times are GMT +1. The time now is 08:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com