I've talked about making the list for your data validation automatically grow with the list. In the past, I've used a macro or the OFFSET formula, but today ...
Keywords for this video: Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Table, List, Validation
This video is current as of January 29, 2009
For more resources for Microsoft Excel: