Behavior of tables & data validation
Posted on 2014-01-27
Hello - I'm trying to automate a data maintenance worksheet that will feed pivot tables & charts on other tabs.
It already had ~100 rows, and I converted that range into a table
Then I added data validation lists as needed
But now when I go down to the first empty row to add new data, the table does not enlarge to include the new row, and the data validation lists are not on the new row.
Shouldn't the table expand to include a new row?
Is there a way to make the data validation lists effect the new row?