How can i linked the RED to "15-771.pdf" and need autofill function?
For example:
15-0772 <------ linked to "Hard%20copies\2015\15-0772.pdf"
15-0773 <------ linked to "Hard%20copies\2015\15-0773.pdf"
15-0774 <------ linked to "Hard%20copies\2015\15-0774.pdf"
15-0775 <------ linked to "Hard%20copies\2015\15-0775.pdf"
15-0776 <------ linked to "Hard%20copies\2015\15-0776.pdf"
15-0777 <------ linked to "Hard%20copies\2015\15-0777.pdf"
=HYPERLINK("Hard%20copies\2015\"&ROW(B782)&".pdf","0"&ROW(B771))
Bookmarks