Hyperlink in excel


I'm using microsoft excel 2010

I've a workbook with 5 sheets... in sheet 5 i want to create a hyperlink... the link goes to a cell, say A50 in sheet 1..... but i may delete a row in sheet 1... now the hyperlink goes wrong.... i want my hyperlink created in sheet 5 to get updated in realtime... what is the solution
Top Bottom