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.

Attached Files

LISTE ANGAJATI.xls (474.0 KB, 9 views)