Creating an easy way to input data to an existing excel table.

Question

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.

Answer 1

Hi, @smunnis17
Welcome to the Q&A Forum.
After testing, it is temporarily unable to meet your needs with the current functions of Excel.
It is recommended that you learn about the relevant content under the office-vba-dev tag or go to the office developer.Thanks for your understanding.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.