I have an employment certificate template designed in the Word, as shown in the Sheet 2 of the attached workbook
LISTE ANGAJATI.xls. This certificate is issued individually for every employee of the tables (Sheet 1) and the list content is changed periodically. My question is how could I make a drop-down list / other method, tool etc. to be linked directly with the table(s) from the Sheet 1, so that I may select the employee’s name and insert it in the dedicated space (text box, free space etc.) from certificate. I mention also that the Word document may be either in a sheet of the Excel workbook (as in the linked file), or an independent external file.
Thank you!
P.S. Due to the large amount of names and their permanent change, a drop-down list manually updated is impracticable.