Automatically Grow Excel Validation List

Описание: Excel List validation function doesn't automatically include any new values inserted into the list. To work around this problem, put your validation list into a table, use the "INDIRECT" keyword with the table and column name, and you'll never have to maintain this validation function again.