Dynamic Hyperlink Based on Cell value

HolyLemon

New Member
Joined
May 13, 2010
Messages
46
Is there a way to create a hyperlink that is dynamically linked to a cell value, in which the cell value points to a cell reference within a worksheet, and that when the value is changed can point to a different cell reference.

I am looking for a way to create a hyperlink without using Macros. I have a column (P) in a worksheet called Annual Review. Everything in column P is an automaticly generated Row number referencing the customers details on the other worksheet "MGP4" So if in P2 on "Annual Review" it says 43. I know that the Customers Details can be found on line 43 on worksheet "MGP4".

Im looking for a way to make it a hyperlink but as a formula so i can copy it down, there are several thousand entries on both worksheets.

If anyone can help me or has any questions i would be very grateful.

Thanks,
Harry
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Hi,

As Andrew is off-line, i have taken the liberty of responding:):)

This is what you are after??

Cheers,
Ian

Excel Workbook
B
5nice name
Sheet3
 
Upvote 0
Hi

Would this work with a formula embedded also?

one would be an =offset and another is an =if formula.

Thanks
Richard
 
Upvote 0
Try:

=HYPERLINK("#MGP4!A"&P2)

You can add a second argument for the text to display if you want.

Question on the same line. I have two sheets. Column A of sheet 1 is having n entries and Column B of Sheet 2 is having same entries but not in the same order. I need to link those entries. How to do that?

Thanks in advance.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,099
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top