Excel Data Validation List from another Worksheet - Spreadsheets

Excel's data validation options include creating a drop down list using data from another worksheet. ... Using data from another Worksheet in the Data Validation List ... Opening the Data Validation Dialog Box ... Excel 2007: Simply Create a Drop Down Lis

spreadsheets.about.com