Learn Excel Episode 379: Offsheet Validation

Posted in Companies, Podcasts on July 04, 2008


Learn Excel Episode 379: Offsheet Validation

Yesterday's netcast showed how to set up data validation to create a dropdown for a cell. The one problem is that someone might inadvertently delete a row from your list of values. Technically, Microsoft says that the validation list can not be on another worksheet, but Episode 379 shows you the workaround.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel