Hello,

I have been toying around with simplifying a template that eliminates human errors. I've created data validation that is dependent on the value in a particular cell in Microsoft Excel, but I'm hoping to achieve the same thing using Microsoft Word. I have attached a template that is similar to my final product. Below is an explanation of what I'd like to achieve.

In the template, once a classification is selected (either level 1 or level 2), i'd like the Pay Package Table to automatically populate with the rates specific to that Level Classification. In the Content Control Properties for Classification, I have entered the values that I would like to be displayed int he Pay Package Table. Next, I'd like the same thing to occur when the Client Contact is selected. When a contact is selected, i'd like for that contacts phone and email to populate the Contact Phone and Contact Email boxes.

Any help with this would be appreciated.

Thanks,

Attached Files

Template.docm (37.0 KB, 11 views)