Hyperlink Autofill

Originally Posted by DBY

Right I see a little clearer, I think! In cell C5 downwards on the Rating Scheme Sheet try:

=IF('Status Comments'!B4="","",HYPERLINK("#"&ADDRESS(ROWS(C$1:C4),2,3,,"Status Comments"),'Status Comments'!B4))

This shows the name and links to that cell on the Status Comments sheet. Is that correct?

That works, but only if the names don't get resorted (Z-A, or by Date for instance). If they get shuffled, the hyperlink still goes to the original cell, thus showing the wrong name.