If you insert an object (pdf) to a cell (linked or not), can you reference it from another sheet?

[30West]

Good morning,

I have a list of about 10 people.
These folks have added files to a folder (same folder where the excel file is located for ease).

I'd like to run a list where names are in ColA and next to them in ColB I would attach the files (in whatever way makes this work).

I'd like to then, on another sheet, be able to draw up a name and produce the inserted object from the other sheet.

This would avoid having to scan down the list looking for the name.

 

[30West]

Actually, it's a little different than my original post--unable to change the OP.


If I have a cell where a link to a PDF has been created, is there a way to re-produce that clickable link in a different cell?

1. all my documents will be in the same folder as the XLS file.

2. example: A1 has a link now to a PDF, and it opens it fine.

3. I'd like to reference A1 in a different sheet or cell, but only the actual "text" of the link in A1 comes over. I cannot get the link attribute to follow.