Display cell contents with hyperlink from different worksheet

carbfrze

New Member
Joined
Mar 12, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Hello all,
Been using Excel 2016 for many years now. I have a large workbook that I use for my department training checklists. I have a mater check list that I use to populate for all employees training. The document has multiple worksheets that has macros, text, and hyperlinks in some cells. I currently use cell references to pull in the cell contents from the master checklist for the text cells only but would really like to be able to pull in the cells contents that have hyperlinks. For the text cells I currently use the formula ='Sheetname'!A1 which works great for the cells that have text only. That formula works great except for any cell that has a hyperlink it is only displaying the text and does not pull in the actual hyperlink. When I try to use the formula above it only pulls over the "friendly name" / text that is typed in and not the hyperlink that is in the cell.

Any ideas on how this can be done?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

A Durfani

Active Member
Joined
Apr 12, 2019
Messages
256
Office Version
  1. 2013
Platform
  1. Windows
Post your sample data with some expected results with below link
 

carbfrze

New Member
Joined
Mar 12, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I'm on a work pc and cannot install add-ins without permission. Hopefully my attached images will explain it better. Basically on Sheet 2 I would like to use the ='Sheet1'!A2 to be able to display the content from Sheet1 including the hyperlink. As of now it just pulls in the text and not the hyperlink. No matter if the original cell is set as a hyperlink typed out or by using a hyperlink inserted using CTRL+K and using a name.
 

Attachments

  • Screen Shot 2021-03-15 at 10.25.49 AM.png
    Screen Shot 2021-03-15 at 10.25.49 AM.png
    45.5 KB · Views: 5
  • Screen Shot 2021-03-15 at 10.25.58 AM.png
    Screen Shot 2021-03-15 at 10.25.58 AM.png
    55.3 KB · Views: 5
  • Screen Shot 2021-03-15 at 10.26.04 AM.png
    Screen Shot 2021-03-15 at 10.26.04 AM.png
    81.5 KB · Views: 5

Watch MrExcel Video

Forum statistics

Threads
1,129,593
Messages
5,637,294
Members
416,963
Latest member
zazama

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
Top