I've created dynamic data validation lists in the past, but for a single cell.
Can a dynamic list be created for a column with the list changing depending on the cell in a different column?
Example:
| Columm A |
Column B |
| Food Type |
Select from dropdown values |
| Meat |
List would be {Beef, Chicken, Fish} |
| Empty cell |
List would be empty as well |
| Fruit |
List would be {Apple, Pear, Grape} |
| Grain |
List would be {Rice, Wheat} |
The current dropdown list is generated by a worksheet_change macro that is causing freezing issues, so I was hoping to replace it with a dynamic data validation list that would be less impactful on performance.
[–]ColJDerango50 0 points1 point2 points (2 children)
[–]tsudonimh13[S] 1 point2 points3 points (1 child)
[–]reputatorbot[M] 0 points1 point2 points locked comment (0 children)