Hello, I am using Excel 2013. My goal is to have multiple drop down lists that you could select options from, and afterwords, generate a phrase from the options chosen. Essentially I would like each option to have a portion of the phrase and once all options are selected, the phrase is then strung together from the data selected. I would prefer if the phrase could be generated using a macro. Similar to the image below but with different outcomes of course. Phrase.png
Bookmarks