Okay, so I'm by no means an excel guru but I've found myself trying to develop my knowledge.

I seem to have stumbled onto a problem...
The story so far: I have my original work sheet, this contains a variety of information. I have created a macro to take information from certain columns to populate the 2nd worksheet.
I have also created a save PDF macro, to save as the filename stated in one of the cells.

Now comes my query:

Is it possible, on the same macro as the save PDF, to create a hyperlink to that PDF and insert it into the first worksheet?
Now due to the fact the first worksheet has hundreds of rows, I didn't know if it was possible to search the first worksheet for the cell containing the filename and creating the hyperlink in said cell, as the filename will be unique.

I'm really not sure if I've explained this well at all but I hope someone can understand my ravings and lend me a hand.

Thanks
Zak