My co-worker and I are working on some cost summary sheets in excel. We have a few tables that we are using to create this summary table. After we are done we have to print off all the backup from other files after hunting the documents down. We would like to know if there is a way to do the following:

1. Select Title of Document such as 220kV from a drop down list (which the code knows that we need to look for our document in the folder labeled 220kV on the server)

2. Select Description such as gen-tie line from a drop down list (which the code knows that we need to print that document as our back-up)

Is there a way to do this? I am new to all of this but I have faith it can be done and might be easy to set up but I only know basic advanced information in excel and no clue how to do macros or coding. Any and all help is greatly appreciated.

Thank you so much!