Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets ...
Houston Chronicle

How to Add Columns to a Data Table

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...