Excel Forum

Excel Magic Trick 414: Retroactive Dynamic Ranges!

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.

Got a Question? Ask it Here in the Forum.