Hello

I'm trying to use the hyperlink function to create a link that will take me to the end of the data set in the last column even when more data is added.


The data is entered beginning in B1 then C1 then D1..... I would like to create a dynamic hyperlink that goes to the last column as more data is entered.

I know how to create a dynamic hyperlink to take me to the last row of a column. But in this situation the data is transposed and the hyperlink needs to go to the last column.

Thanks