Email hyperlinks, cell referencing them and auto update

[Venncathy1]

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 that address.  I have had to do it manually.  As there are multiple users is there anyway to automate this.  Also when the email changes can this automatically update the other sheets??

Thank  you

[#2 · Accepted solution]

@Venncathy1 

*Work with links in Excel

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.

[#3]

Thank you so much I will try this. very helpful

[#4]

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

[#5]

@NikolinoDE

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

[#6]

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