Hi I'm building a parts list data base which has embedded pdf's (this is so it can be accessed offline by anyone)
I have built a test spreadsheet to get the logic right before expanding it too 200+ parts
There are four columns and in column D I have created a Hyperlink named the same as the cell with the following code behind it:
In the Data sheet worksheet I have placed the pdf files and named them the same as the part numbers.Please Login or Register to view this content.
This code works fine but not very scaleable in terms of the 200+ parts to be added to the actual sheet.
The sheet has to be maintained and lines added and deleted when necessary so I would like this to be as easy and automated as possible could you help please?
I have attached example Sheet to hopefully illustrate.
Bookmarks