LinkBack URL
About LinkBacks
Hi All,
is it possible to automatically hyperlink a cell to a .pdf automatically based on a diffferent cells value.
EG.
C4 = 1234
N4 = 1234.pdf
Hi All,
is it possible to automatically hyperlink a cell to a .pdf automatically based on a diffferent cells value.
EG.
C4 = 1234
N4 = 1234.pdf
Put this formula in N4. Change the file path to suit.
=HYPERLINK("C:\MyFolder\" & C4 & ".pdf", C4 & ".pdf")
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Yes - it's possible
Are all the PDFs in the same folder?
If not, then
EITHER the cell value needs to include the full path
OR
you need a lookup table elsewhere with the cell value in column1 and the full path in column2
Which will work for you?
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
They are not all in the same folder but i have used the =HYPERLINK("C:\MyFolder\" & C4 & ".pdf", C4 & ".pdf") and this has worked a charm so thanks for your help!
You are welcome.
Thanks for the reps and marking the thread as solved
You're welcome.
You could put the folder path in say B4 and use this.
=HYPERLINK(B4 & C4 & ".pdf", C4 & ".pdf")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks