Episode 584 - Refreshable Validation
Store your validation lists on a separate worksheet and have the dropdown boxes automatically expand when you add new items to the list. Episode 584 shows you how. If you'd like to try this out, download the sample workbook. Monday in the USA is our Labor Day holiday and I'll be back Tuesday, September 4th.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!