Copy and Paste Hyperlink

[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?

 

[Peter_SSs]

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

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread since the other one contains an image so please continue in the linked thread. If that happens in the future, just reply to your own thread and add the additional information/image etc, don't start a new thread.