When data entry is strictly defined, it is nice to have data validation list in place, so entries are uniform. Furthermore, a nice way to make data entry faster is to have “smart lists”, or dependant lists. What does this mean?
When you choose an option from drop-down list in a column, you need only possible options listed in another column, based on the first choice. Let’s look at a simple example with dogs and cats.
Example file is attached.
read more - from ExcelExperts.com blogs http://ift.tt/1bhwIU7
