See how to create dynamic ranges after you have built all your formulas, Data Validation, Charts and Pivot Tables (PivotTables). The Excel 2003 List feature and the Excel 2007 and Excel 2010 Table feature will all retroactively adjust all ranges used in all Data Validation Rules, Charts, Formulas, and Pivot Tables.
Questions about Excel Magic Trick 414: Retroactive Dynamic Ranges!
Want more info about Excel Magic Trick 414: Retroactive Dynamic Ranges!?
Get free advice from education experts and Noodle community members.