• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1704
  • Last Modified:

Excel: How to Copy Hyperlink Cell To Another Cell

I have a simple equation that returns a value in a cell so that when you click on it, it is a hyperlink. This works. = IF(AC7>0, (HYPERLINK((VLOOKUP(AC7, $AM$7:$AN$3000, 2, FALSE)),AC7)), ""). It returns a "friendly location" which is a 4 digit number and a link location (on the web) when you click on it.

How do I copy and paste just the VALUE to another cell so that again, when you click on that copied value, the hyperlink works. Right now, the value is copied but it is no longer a hyperlink. I can't have the equation in the new cell because of other reasons.

  • 2
  • 2
  • 2
1 Solution
Your formula is trying to find a cell in the range specified for the value (same as in AC7). Note that the lookup range is fixed but AC7 is not an absolute reference, so when you copy/paste the formula into another cell the reference going to chnage(somethin else in place of AC7). Please make sure that the value of the new reference does exist in the range. Then the hyperlink should work. You can attach a sample sheet, so that I can get a better idea of your problem.
I would insert a column next to your current formula that does the VLOOKUP of the hyperlink

=VLOOKUP(AC7, $AM$7:$AN$3000,2,FALSE)

that would be your list.

To make it "hot", naturally it would be


Hope this helps.
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

u002dagAuthor Commented:
Hi SantaBaby,
Thanks for the quick response. I attached a sample sheet as you requested.

Need 4 Digit Value in Column B, copied to column A with the hyperlink of column B      
So it's no longer an equation that's being copied over.      

I found this on the web, is it of any help?

But this code fails if source cell doesn't contains hyperlinks

Sub copyHyperlink()
r = Selection.Rows.Count
For i = 1 To r
ActiveSheet.Hyperlinks.Add Anchor:=Selection.Cells(i, 2), _
Address:=Selection.Cells(i, 1).Hyperlinks(1).Address
End Sub

Could you please try to change your formula?
Add a $ sign befor ecah reference C column in your formula.
Example: Change the formula in B8 from:

= IF(C8>0, (HYPERLINK((VLOOKUP(C8, $D$7:$E$3000, 2, FALSE)),C8)), "")


= IF($C8>0, (HYPERLINK((VLOOKUP($C8, $D$7:$E$3000, 2, FALSE)),$C8)), "")

Once you complete the change, copy B8 and apply it to other cells in column B to change all formulae in column B.

The the formua will refer to C coulmn for lookup, no matter where you copy it to (as long the destination is in the same row).

You can try your copy at this point.

Please let me know if this helps.

u002dagAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now