Printing hyperlinks content (.PDF)

[McQuinge]

Hi!
I wonder how to print out several pdf documents from hyperlinks in an excel sheet?

I have a folder with 1500 pdf files. I have made an excel sheet with a hyperlink to each of the documents. I use the sheet so I can filter the documents on differents keywords and organize them for example in ascending order.

And now I want to print some of these documents out. How can I do this an easier way then open each hyperlink and press print?

In the example I can filter by keyword "1".
It will show 4 lines with links. Some links will be duplicate and in the print function I just need one sample of each document.

Thanks for the help!

Regards McQuinge