Learn Excel Episode 720: Dynamic Validation

Posted in Companies, Podcasts on July 14, 2008



Jonathan is frustrated that his validation scrollbars start in the midst of several blank cells that he set up in his validation list. He was doing this to allow room for future growth in the list.Instead, Episode 720 will show you how to set up a dynamic named list using the OFFSET function.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Validation, Dynamic Range, Offset