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.
0556723
Jan 23, 2024Copper Contributor
There is a possibility that the hyperlink will appear even if I called it a name in the first cell, for example if the address in the first cell =HYPERLINK("D:\Users\User\Desktop\accident\D07_20230622122447_003.mp4","hcaim")
And I want the same thing to appear in the second cell, there is something to be done
And I want the same thing to appear in the second cell, there is something to be done