How to Create Dynamic Named Ranges in Excel

How to Create Dynamic Named Ranges in Excel
Now that you understand the named range (Here is it:    • What is Named Range & How to Use it in Excel  ), it’s time for dynamic named range. Dynamic name range is basically a dynamic list with a name. Usually, name range has specific data range that is kind or hard coded. If you add an item to that list you need to go to the name manager and update the named range source manually. But in Dynamic range you don’t need to do it. The name manager automatically updates the list. This is what you are about to learn in this tutorial.
The trick is to use the Offset and CountA (How to Use COUNTA Function in Excel:    • How to Use COUNTA Function in Excel  ) function combinedly in your name manager source.
You count all the cells with value inside your range and then pass it to the name manager with offset function. Then the name manger updates your named range thus making it fully automatic. That’s how you create dynamic named ranges.

#Dynamic #NamedRange #Excel

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Excel Data Validation: Allow Specific Entries, Dates, Dropdown lists and More: http://bit.ly/49kV7vD


Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial