Hey friends,
I am in search of a new way to do conditional data validation dropdown lists within an excel table.
Here's what I understand:
What I want:
Instead of having to create an entire new table for each conditional dropdown, I would prefer to have one table that would look like the below table.
I would prefer this method because I am then managing one table for all groups instead of over 100 tables for 100 different groups.
Is there any way I can make this work with VBA or otherwise?
Thanks in advance for any help you can offer
I am in search of a new way to do conditional data validation dropdown lists within an excel table.
Here's what I understand:
- Creating tables and defining that table as a named range will create an automatically updating dropdown
- I can type that named range as a string value within a cell and reference that cell with an indirect formula in a data validation list to create a conditional dropdown.
What I want:
Instead of having to create an entire new table for each conditional dropdown, I would prefer to have one table that would look like the below table.
Group Sub-Group Group 1 Sub g Group 1 Sub f Group 1 Sub x Group 2 Sub r Group 2 Sub m
<tbody>
</tbody>
I would prefer this method because I am then managing one table for all groups instead of over 100 tables for 100 different groups.
Is there any way I can make this work with VBA or otherwise?
Thanks in advance for any help you can offer