enter a hyperlink in one cell on a worksheet and it copy to other worksheets

[bpolkusm]

Hello Everyone,

I have a workbook and on the Summary tab worksheet in Cell C41 I have a hyperlink to a website. The workbook has 111 worksheets The website changes for each client for each workbook. I am looking for a formula or something that when I update the hyperlink on Summary Tab in Cell C41 it copies that hyperlink as a active link to Cell E10 on the other work sheets.

 

[My Aswer Is This]

Are you saying here. Your quote:
The website changes for each client for each workbook.
Do you mean the Hyperlink will not be the same in each worksheet?

 

[My Aswer Is This]

If your wanting to modify the Excel Hyperlink in Range("C41") of the Summary Tab
and this same link will be entered in all sheets in your workbook Range("E10")

Put this script in the summary sheet:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the Summary sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$41" Then
'Modified  4/5/2021  10:54:36 PM  EDT
Dim i As Long
Dim ans As String
ans = ActiveSheet.Name

For i = 1 To Sheets.Count

    With Sheets(i)
        Select Case Sheets(i).Name
        Case ans
            Case Else
                Target.Copy Sheets(i).Range("E10")
        End Select
    End With
Next
End If
End Sub

 

[bpolkusm]

Are you saying here. Your quote:
The website changes for each client for each workbook.
Do you mean the Hyperlink will not be the same in each worksheet?

The hyperlink will stay the same for each worksheet with in each workbook. I am trying to prevent the client from having to go all the way back to the summary tab to get to the link and my team not to have to update 111 worksheets with the same website.

 

[My Aswer Is This]

The hyperlink will stay the same for each worksheet with in each workbook. I am trying to prevent the client from having to go all the way back to the summary tab to get to the link and my team not to have to update 111 worksheets with the same website.

So did the script I provided do what you want?
If not please explain more.

 

[bpolkusm]

So did the script I provided do what you want?
If not please explain more.

yes, thank you

 

[My Aswer Is This]

yes, thank you

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.