• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

hyperlink to copy cell value

ajaar

Member
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
 

Hui

Excel Ninja
Staff member
Shouldn't it be
=HYPERLINK("C:\General\" & $BL$24,"Click here.....")

putting " 's around $BL$24 makes it equal to the string $BL$24
 

ajaar

Member
Hi Hui,
Thank you for the reply.
Sorry it was a typo in my function. my formula already like as you said.
for example i have this formula in workbook Master sheet1, there is value in BL24, that value in coming the funtion. when i copy this formula to new workbook temp1, there is no value in BL24. So hyper link is incomplete.

What i wanted, when i copy formula Master to temp1, i want to value to BL24 remain same( cell value has to come in the formula, instead of cell address).

Hope it is clear

HYPERLINK("C:\General\" & $BL$24,"Click here.....")

Regards,
Ajaar
 

Hui

Excel Ninja
Staff member
If you select the cell with the hyperlink
Press F2, then F9
Excel will replace $BL$24 with the value from BL24
Press Enter to save it
Now copy the cell and paste in the new workbook
 

ajaar

Member
Dear Hui,
Thanks you for the reply.
When i did F2 then F9 , entire hyperlink disappear and remain "click here" in the cell.
Wehn i select only part $BL$24 manully and click F9, it works as you said.

is there any way to do it automatic like combination of other formula, doing manuly will not workout in my scenario.

i wish if there were a formula ' =value($BL$24) :)

Regards
Ajaar
 

ajaar

Member
Hi Hui,
Thanks for your support. it is not working.
I pasted hyperlink throgh VBA.

Thanks
Ajaar.
 
Top