In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call.
- Validate Data Based on a List on Another Worksheet
- Control Conditional Formatting with Checkboxes
- Identify Formulas with Conditional Formatting
- Count or Sum Cells That Meet Conditional Formatting Criteria
- Highlight Every Other Row or Column
- Create 3D Effects in Tables or Cells
- Turn Conditional Formatting and Data Validation On and Off with a Checkbox
- Support Multiple Lists in a ComboBox
- Create Validation Lists That Change Based on a Selection from Another List
- Force Data Validation to Reference a List on Another Worksheet
- Use Replace... to Remove Unwanted Characters
- Convert Text Numbers to Real Numbers
- Customize Cell Comments
- Sort by More Than Three Columns
- Random Sorting
- Manipulate Data with the Advanced Filter
- Create Custom Number Formats
- Add More Levels of Undo to Excel for Windows
- Create Custom Lists
- Boldface Excel Subtotals
- Convert Excel Formulas and Functions to Values
- Automatically Add Data to a Validation List
- Excel's Date and Time Features
by updated