Forum Discussion
Venncathy1
Sep 18, 2023Copper Contributor
Email hyperlinks, cell referencing them and auto update
Good Afternoon I have a workbook with 50 sheets within it. I am trying to cell reference to an email hyperlink in the first sheet. It does bring back the address but not the correct hyperlink to t...
- Sep 18, 2023
In the first sheet, enter the email addresses as hyperlinks in cells, or use the "Insert Hyperlink" feature to create the hyperlinks. Make sure the email addresses are in a consistent format.
In another cell (e.g., a neighboring cell), you can use a formula to reference the hyperlink address. Assuming the hyperlink is in cell A1, you can use the following formula to reference it:
=HYPERLINK(A1)
This formula will display the email address as a clickable hyperlink. Clicking on it will open your default email client.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.
NikolinoDE
Sep 18, 2023Gold Contributor
In the first sheet, enter the email addresses as hyperlinks in cells, or use the "Insert Hyperlink" feature to create the hyperlinks. Make sure the email addresses are in a consistent format.
In another cell (e.g., a neighboring cell), you can use a formula to reference the hyperlink address. Assuming the hyperlink is in cell A1, you can use the following formula to reference it:
=HYPERLINK(A1)
This formula will display the email address as a clickable hyperlink. Clicking on it will open your default email client.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.
Venncathy1
Sep 18, 2023Copper Contributor
Hi Yes this does help to make it a clickable hyper link. The thing that I cannot get working is the copied hyperlink address stay's as the previous one. The workbook is a template and forwarded to multiple users. When they put their email address in it changes the actual address not the link, that is still the previous one. Not sure if this makes sense??
Thank you
Thank you