Forum Discussion
Adding Items in Table for Data Validation Menu
I have a couple tables that I'm using as the source for some Data Validation drop down menus. If I want to add items to these tables and have them automatically update in the drop down menus, I'm hav...
Hello Adam,
Assuming your items are Item1 to Item4 and are listed in A1:A4, name your list as “Items” with this formula:
=INDEX($A:$A,1):INDEX($A:$A,COUNTA($A:$A))
In the cell where you want to place your drop-down list, your source is:
=Items
Thereafter, any item that you add before Item1, after Item4, or anywhere between them, shall be automatically included in your drop-down list.
Assuming your items are Item1 to Item4 and are listed in A1:A4, name your list as “Items” with this formula:
=INDEX($A:$A,1):INDEX($A:$A,COUNTA($A:$A))
In the cell where you want to place your drop-down list, your source is:
=Items
Thereafter, any item that you add before Item1, after Item4, or anywhere between them, shall be automatically included in your drop-down list.