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