Learn Excel Episode 937: Dynamic Validation

Posted in Companies, Podcasts on February 04, 2009

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 Morne sends in a beautiful solution for either Excel 2003 or Excel 2007 to build a dynamic validation list. Episode 937 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Validation, List, Table