Monday, August 29, 2011

Excel: Data validation - select a value from a list from other sheet

You could select a values for a list in other sheet. Steps for MS Office 2007 are:
1. Select the cell you want to change.
2. Data -> Data Validation -> Settings
3. Field: Allow = List
4. In Source field, enter a value similar to:

=Sheet2!$A$2:$A$5

This is the range from Sheet2 cells A2 to A5

The result is a dropdown for the value of the cell.

No comments:

Post a Comment