Hyperlink dragging

I would like to copy a large selection of hyperlniks down a column of 200 plus cells and would the hyperlink to increment as I drag the cells downwards.

Is there a simple way to copy and paste down a large selection of cells, so that I do not have to edit each hyperlink individually

Have enclosed example.

Hope this makes sense, appreciate any help, re any formula / code.

Thanks

Replace cell C6 with this formula:

=HYPERLINK("#Sheet2!"&ADDRESS(ROW(D6),COLUMN(D6)),"Link to")

copied down

You're welcome.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save