Issue with Hyperlink

i created a hyperlink in sheet 1, when i copied the sheet into sheet 2 and clicked on the link it goes back to sheet 1. Is there any way that i can create a new sheet and the link stay on the new sheet without editing the hyperlink? Pls help.

Thanks in advance.

Originally Posted by TuTu

i created a hyperlink in sheet 1, when i copied the sheet into sheet 2 and clicked on the link it goes back to sheet 1. Is there any way that i can create a new sheet and the link stay on the new sheet without editing the hyperlink? Pls help.

Thanks in advance.

Simplest way is to give a range name to the cell that you want the hyperlink to go to, rather than a cell address.

HTH

Hi Richard,

Pls pardon me , i'm new to excel. How may i give a range name? Thanks