Scroll Bar Form Control & Hyperlink

[Jonathan Sidebottom]

Hi everyone

I have uploaded a file with some dummy information.

The first sheet has four columns and 249 row. The second sheet contains a smaller area, with a custom scroll bar.

I can get this to work correctly in principal. The issue is that I am trying to have a hyperlink in the scrollable area. The hyperlink would combine the ref and URL from sheet 1. However it seems that using the offset function has caused to the hyperlink functionality to drop off.

Can any one out there suggest a solution?

Thanks very much
Jonathan

 

[Chihiro]

Formula can only bring in string. Not the hyperlink.
You could just reconstruct the hyperlink using formula.
=HYPERLINK(OFFSET(Sheet1!$C1,Sheet2!$D$1,0),OFFSET(Sheet1!$D1,Sheet2!$D$1,0))

 

[Jonathan Sidebottom]

Hi Chihiro

That's amazing. Thanks for the quick reply, that has bee a great help!!

Cheers
Jonathan

 

[Aysher Ryan]

Agreed with @Chihiro