Dear Experts,
I am really having rough time with this.
I have below hyperlink function in a worksheet, when i copy hyperlink to another workbook or another sheet, i wanted to consist the value in "BL24". i dont wanted to change the value of BL24. is ther any way to do this.
Thanks for your help in advance.
=HYPERLINK("C:\General\"&"$BL$24","Click here.....")
Regards
Ajaar
I am really having rough time with this.
I have below hyperlink function in a worksheet, when i copy hyperlink to another workbook or another sheet, i wanted to consist the value in "BL24". i dont wanted to change the value of BL24. is ther any way to do this.
Thanks for your help in advance.
=HYPERLINK("C:\General\"&"$BL$24","Click here.....")
Regards
Ajaar