I have what is hopefully a simple request, but was unable to get enough specific help with only the search function to complete this task myself.
What I have:
I have a vendor-supplied bill of materials spreadsheet with part numbers in a column. I want to single-click select any cell containing a drawing number, then click one "button" with a hyperlink to open the pdf drawing, based on the value of the selected active cell.
For the following example, the text displayed in the cell is "1234567" and is the part number. My current hyperlink looks like this:
"http://cad.company.com/vault/AccessFile.asp?DrawingID=1234567&Source=FM&FileType=PDF"
My question(s) is/are:
What is the proper syntax to obtain the active cell value and replace it in the hyperlink? Is it even possible?
I know I could set up separate hyperlinks for each cell, but I would like to do it this way to save time and reduce errors. (I do not know VBA, yet.)
Thanks!
Bookmarks