B C D E 10 Contract_Type Company Name Contract period Employee Name 11 Unlimited Adam 12 imited Apple 2Years John 13 ForFemale Daycare Celiena
Hello,
I’m a new to excel VBA and would appreciate it greatly if someone could assist me in this issue.
I have the above table in excel start in "B10" and it is populated when a user completes a userform and clicks a 'Save' Button.(I have multiple userform and one database ).
Once they have saved an 'Export' button is enabled and the user can export the last record (row) submitted by the user form to word template in the relevant locations on the template (I want to open different templates based on Contract Type).
I have created bookmarks in the attached word templates and would like the data to be exported to these locations.
1. ( Contract_Type ,Company Name and Employee Name) for the Unlimited and for female contracts .
2. (Contract_Type ,Company Name, Contract period and Employee Name) for the Limited contract .
Bookmarks