Forum Discussion
Solved
Add a cell with text according to a list of choices - VBA
Hi everyone, don't know where to start this kind of macro. But I have 3 lists that if I selected one from the lists, it will then populate certain text in a cell. Say for example on the attached file...
Okay, please find the attached and once you select any cell in the range B1:D1, the corresponding ingredients list will be populated.
It wouldn't have to involve macros or VBA routines. This can be done with what I've called a cascading set of Data Validation steps. I've attached an example that works with first and last names, but the same logic could apply to sets of ingredients based on a first selection of the dish to prepare.
Note: these functions do require the most recent version of Excel. Here's a YouTube video that explains the Dynamic Array functions. https://www.youtube.com/watch?v=9I9DtFOVPIg
