Hyperlinked cell not working in the autofiltered sheet

Occasional Visitor

I have created a database of downloaded research papers of my interest. I have also hyper-linked those files so that it will be easier for me to open them later on. All hyperlinks are for .pdf files

I have also added one more feature i.e. use of the auto-filter function to create a dynamic search using macro and displayed the results in another sheet of the same workbook. The macro is running perfectly. However, those cells which were hyperlinked before in the main table are no more linked with my PDF files after the data has been filtered.

I tried to solve this issue but I couldn't fix it till now.

Can you please help me to figure out this issue? If you need any additional information, please let me know.

0 Replies