Forum Discussion
Dynamic data validation lists populated from another cell
I am trying to achieve two things which I presume are possible but I'm unsure of where to start. What I am hoping to achieve is to populate the list (shown in cell C4) with the data ente...
I don't think that is possible, or if it is, it'll be complicated.
Instead of entering the options in a single cell, enter them in a range of cells, with one option per cell. Then set the source of the data validation list to that range.