Hyperlink Dragging with Large Increment

[Fpob]

Hi,

I know how to drag a hyperlink using the =HYPERLINK formula, but can only get it to work with an increment of 1.

Is there a way to have the increment be larger than one? In this case, by 13 cells?

I attached a sample file.

[DonkeyOte]

One approach

Sheet1!B2:
=HYPERLINK("#Sheet2!B"&2+13*(ROWS(B$2:B2)-1), "GO")
copied down

[Fpob]

Thanks so much! Works perfectly.