So right now I have set up a table in excel that i use to somewhat automate a word document through mailings.
I have a set of cities, and for each city i have specific data that i have to research and include in a report. The report has the same exact wording and format for all cities besides the results for the data points that are specified in the excel table (for example: the name of the city). I set up a template for the report on word that has all formatting done and other wording, and imports the data specific to each city from the table via the Mailings feature.
My question is this:
Is there a way to set up a friendly user interface for filling in the table? Right now my only method would be to tab through the table of a lot of rows and columns and input the data.
I would like some solution where i can select the City, then answer prompts and it goes into my existing table that is used for the mailings. Is it something that I can create in another sheet of the same excel document? that would be best. I was thinking a sheet that has all the questions laid out, then depending on what city you select it shows you what the table has for those questions. then you can go in and edit things and it changes the table based on what you do.
