When you create a named range in Excel, it doesn’t automatically include new items. If you plan to add new items to a list, you can use a dynamic formula to define an Excel named range.
Then, as new items are added to the list, the named range will automatically expand to include them.
Get the sample file and written steps on my Contextures site:
https://www.contextures.com/xlnames01.html

Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: https://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1
#ContexturesExcelTips #ExcelQuickTips

Video Timeline:
0:00 Name a Range of Cells
0:38 Add New Item to List
1:22 Start a Dynamic Named Range
2:03 Dynamic Named Range Formula
4:30 Test the Dynamic Named Range
4:53 Add New Item to Dynamic List

Please take the opportunity to connect and share this video with your friends and family if you find it useful.