Happy New Year!

I work in a company that generates many contracts per year, but working across different states we have to reference State-specific Legislation in each agreement (taking up over 20 pages, making the agreements seem more daunting than they actually are). At the front of the document, you need to select the Jurisdiction that the contract will be in, and I am wanting to use this drop-down to govern the formatted text so that only the relevant Legislation for that state is shown.

This is well beyond my level of knowledge. The solution would need to be transportable with the document (ie. Not saved only to my Normal.dot file) as many people will be involved in drafting documents, and for the text to be properly formatted and look professional. Is this achievable or do I need to call in a specialist? I have been tinkering and researching for 12 months to no avail.

I have seen several solutions, but they do not provide formatted text, or they require a change to your Normal.dot file, or don’t play nice with newer file formats.

I am also keen to explore other functionality, such as:

- Selecting a check box for one item which changes a comment from Not Applicable to Insert
- Selecting a company auto-populates their company number, and so on
- Conditional Formatting would be useful to prompt someone to make a selection, which would be highlighted blue to prompt them for a selection, with the highlighting removed once a selection is made

I hope this makes sense, and I think I could cut the complexity in half by these small changes (not to mention the time saved drafting each individual document). I welcome any input you may have, and thanks for adding me to your forum!