Copy and Paste in Hyperlink from a sheet to another separate sheet

[llzizoll]

I have more than 286 hyperlinks in a sheet where every hyperlink cell is linked to the below cell (for example: A1 is linked to A2, B1 is linked to B2 ... and soon on.

Now, I have to do this in 31 sheets representing 31 days. So, it doesn't make sense to make hyperlinks to 8861 cells (286 X 31=8861)

I tried to copy and paste, I tried to make copy of sheets, but when I click on any hyperlink cell in any of the 31 sheets, it links me back to the original sheet (lets say Sheet 1)

I tried to paste special (Link), it didn't work either.

Is there a way to make it done in easy way?

 

[Akuini]

Hi, @llzizoll

Is there a way to make it done in easy way?

You need vba to do that.
1. Can you post just three of the sheets name?
2. I need to know what the address & subaddress of the hyperlink looks like.
So:
- select the first sheet then run the code below.
- the result is in immediate window.
- post the result here

Sub getLink()
Dim hh As Hyperlink, i As Long
With ActiveSheet
    Debug.Print .Name
    For Each hh In .Hyperlinks
        Debug.Print "Address: " & hh.Address & " - " & "SubAddress: " & hh.SubAddress
        i = i + 1: If i = 6 Then Exit For
    Next hh
End With
End Sub