Web links in search results not clickable

[Reyaaz]

Search results are listed on Sheet 1 (Search Results), and gathered from sheet 2 (Full Product List).
However, cells which contain a web link in Full Product List, are not currently clickable in Search Results.

Column 1 names are clickable in the full list on Full Product List.

The user is currently unable to click through the column 1 web links in Search Results, after performing a search, with Column 1 seeming to hold normal text.

Example of Sheet 1 shown.

Thanks

 

[Dan_W]

I've not encountered this before, but I can see why hyperlinks on one sheet wouldn't necessarily track through to another sheet. Odd, though, that the blue underline formatting is nonetheless reproduced.

By what method, are these search results being arranged and reproduced on the search results sheet? Is it through a filter? Or VBA? Or...?

Also, the original hyperlinks - how have they been assigned to the cells? Manually? Or using the HYPERLINK formula?

 

[Reyaaz]

I've not encountered this before, but I can see why hyperlinks on one sheet wouldn't necessarily track through to another sheet. Odd, though, that the blue underline formatting is nonetheless reproduced.

By what method, are these search results being arranged and reproduced on the search results sheet? Is it through a filter? Or VBA? Or...?

Also, the original hyperlinks - how have they been assigned to the cells? Manually? Or using the HYPERLINK formula?

Hi, Dan.

Please check this post to give you an idea of how the search results have been arranged:
Exact text search in a range of cells

The original hyperlinks were inputted manually in column 1 of Full Product List.

Thanks

 

[Dan_W]

Thank you for the additional information. I checked the thread, and it seems that Jason has come to the same point as what I was trying to get at with my questions - namely that filtered data only reproduces text, and not everything else that has been done to the cell. Which I think means that in your screen shot, you must have manually formatted the cells in column A to be blue with underlined in order to make it appear as though they were hyperlinks.

In any event, I agree with Jason's assessment - this would require a different strategy. Advanced filters is possibly the most straight-forward but would require a bit more user-interaction. VBA would be the easiest for end-users, but I know that some companies can be a bit touchy about VBA enabled workbooks.

 

[Reyaaz]

Thank you for the additional information. I checked the thread, and it seems that Jason has come to the same point as what I was trying to get at with my questions - namely that filtered data only reproduces text, and not everything else that has been done to the cell. Which I think means that in your screen shot, you must have manually formatted the cells in column A to be blue with underlined in order to make it appear as though they were hyperlinks.

In any event, I agree with Jason's assessment - this would require a different strategy. Advanced filters is possibly the most straight-forward but would require a bit more user-interaction. VBA would be the easiest for end-users, but I know that some companies can be a bit touchy about VBA enabled workbooks.

Thanks for the response.
Nope. I didn't manually format the cells in Column A. The search results seem to copy that particular format over. I don't know why.
And yes, you are right re the VBA enablement.