Hi all

I'm putting together a sheet which allows a hyperlink to a cell which is way further to the right in the sheet. I.e. C3 is a link to cell BT3

I also want to do this for C4 to BT4, all the way to C100 to BT100.

However, issue arises. In C3, if I do ctrl k and reference cell BT3, that works great! I click on the text and it brings me right to BT3. But if I drag that down, every cell below will also link to BT3, and not the cell directly to its right in column BT.

If I use the hyperlink function, I can get the values to change appropriately, but then clicking on the text in the cell doesn't bring me straight to the BT column

Is there a way to add in this hyperlink so that clicking C3 will bring me to BT3 AND if I drag that all the way to C200 it brings me to BT200?