I have been trying to make this work for a few days now to no avail. I am writing a document that has three pieces of information in it that needs to be repeated and or auto-populated based on the first selection (city,state). The other two are contract number and hotel name. Both contract number and hotel are hard set (only one per city) but the city,state could be one of 65 cities. I need to select the city name on the title page and it auto-populate the contract number and hotel name throughout the rest of the document.

I am new to VBA and have tried to do it using this but no success. I have also tried references and everything else I could try after reading forums.