This video show you how to create a dynamic range selection and create a dynamic chart based on a start and end date. There are different advanced concepts presented here like dropdowns with a data validation list, named ranges and using INDEX & MATCH functions to perform lookups. To see other videos on these topics see the URLs below: Data Validation Named Ranges INDEX/MATCH 🔔 SUBSCRIBE to my channel ➜ 🏫 Excel Training ➜ 📚 Excel Books & Tech Gear ➜ ⚙️ Tools: Screencasting ➜ ⚙️ Tools: Microsoft Office ➜ ⚙️ Tools: TubeBuddy ➜ 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to #excel #msexcel #doughexcel -~-~~-~~~-~~-~- Please watch: "Convert Table in a PDF File to Excel" -~-~~-~~~-~~-~-