3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation

VBA/Macros Course (40% Discount): https://www.teachexcel.com/vba-course-update.php?src=youtube_v_description_mnpGO5OMcyQ Excel File: https://www.teachexcel.com/excel-tutorial/2237/3-ways-to-automatically-update-drop-down-lists-in-excel-data-validation?nav=yt Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Ensure that your Data Validation Drop Down Lists or Menus are automatically updated with any new entries or deletions - these automatic methods make maintaining your spreadsheet much easier. The 3 methods that I show you here will cover the 3 most common ways to have your data validation lists automatically update: - a robust and versatile method (the one you should use) - a very commonly taught method, though with some downfalls (also mentioned here) - a formula that allows bypassing some of the steps mentioned in the previous methods These 3 methods should give you a complete understanding of how to automatically update your lists, regardless of the setup of your spreadsheets. I hope you find this tutorial helpful!) Enjoy! TeachExcel.com #excel #tutorial #howto