Hyperlink Inquiry...

[Rh3e]

Hello Excel Experts,

Need help with this situation as can not find a way on how to do it. I have 2 sheets in a workbook. Sheet 1 has a data that has a hyperlinks to different sheets in the workbook. On sheet 2, I have created a filter function to extract the data on sheet 1. My issue is the hyperlinks is not going to sheet 2. Is there a possibility to have the hyperlink created move to sheet 2 when performing the filter function in sheet 2.

Thank you in advance with your answer.

 

[GraH]

Hi, some sample data may help here (see XL2BB, link in my signature). It all depends on your available data in sheet 2. Does that contain cells you can use to create the hyperlink via a formula? Else you'd be needing a macro to extract the hyperlink from sheet 1. Can't help you there.

 

[Rh3e]

Hi GraH,

Thank you for the response. Here is the sample data that you are requesting. On the same sheet create a data for A column A1,A2, and A3. In column B test1,test2, and test3. In cell D1 I create a data validation for B2:B4. The created a function formula in D5. The concern is that the Hyperlink is not moving.

Thank you so much.

 

[GraH]

Would need to know what the hyperlink behind the range A1:A3 is?
If there is nothing "logic", hard to suggest a working formula. e.g. A1 can have a hyperlink to mrexcel.com and A2 to google.com. If that is the case you need a macro.
If they refer to sheets/cells, then you need to know sheetsname and use hyperlink function to reconstruct the hyperlink from the source cell.

 

[Rh3e]

Hi @GraH,

Thank you for responding. Appreciate it. The logic is I have sheet 1 that has a list of processes that has hyperlinks. Instead of using CTRL F to locate the specific process with hyperlink within the workbook in different sheets, decided to create the FILTER function. It does return the said result but the hyperlinks is not included anymore.
Tried vlookup, index and match but the hyperlinks are not included in the results. Did the hyperlink function but getting cannot open specified file error.

 

[GraH]

Any logical sequence in the procedure links?
Like Sharepoint site, folder, DOC name,... Then it boils down to making the hyperlink formula work.
Can you provide a few examples of the links? Then suggestions for formulae might follow.

 

[Rh3e]

Hi GraH,

Thank you for following up. I was able to resolve my concern using =HYPERLINK(VLOOKUP and another formula =HYPERLINK(INDEX(MATCH...
Thank you for responding to my queries.

Reden

 

[GraH]

Good to read you got it sorted out, Reden. Thanks for the feedback.