DYNAMIC Named Range in Excel | ExcelJunction.com
We know what a Named Range is and how it works. Now we’ll see what is a DYNAMIC named range. A dynamic named range expands automatically when you add a value to the range and is very useful for charts or pivot tables. It ensures that the source data is always up to date.