Need to control what information can be entered in a cell? Create a dropdown list from values on another sheet.
In this Raptor Solutions quick hit video, we'll look at how to create a dropdown list using a Table, Named Range and Data Validation. We'll control data input options and produce an error if a useer attempts to enter an invalid entry.
The ability to create a table within Excel brings a few features to light that you may find beneficial. The ease of data depiction as well as the ability to sort any column, search for values or simply apply other filters to limit the list of information, Excel Tables are a powerful tool to have in your arsenal.