Tap into the power of data validation in Excel (free PDF) (TechRepublic) You can’t create a relationship between ordinary data sets. The Data Model works only with Table objects. The example ...

Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, ...