I have created a large number of work instructions using Word templates and I would like to make it easy for our engineers to figure out which template to use for each product. I have created an Excel spreadsheet with drop down boxes that allows them to fill out certain information about the part. Once all the information is filled in, it gives the title of the template they need to use. To make this even easier, I would really like to link the templates to the spreadsheet so when it decides the title of the template needed, it gives a link to the it so all they have to do is click on the link and fill out the sheet. Is this possible? Let me know if this doesn't make sense and I will try to explain it a little better.
Thanks!
Thanks!