How do I validate data from a different sheet?

Create a drop-down list

1. In a new worksheet, type the entries you want to appear in your drop-down list.
2. Select the cell in the worksheet where you want the drop-down list.
3. Go to the Data tab on the Ribbon, then Data Validation.
4. On the Settings tab, in the Allow box, click List.

How do I apply data validation to multiple sheets?

How to apply data validation to multiple sheets at once in Excel?

1. Apply data validation to multiple worksheets at once.
2. Define a range name for your data list which will be created to drop down list, select the data list, and enter a range name into the Name Box, and then press Enter key, see screenshot:

Can you put a data validation list on another sheet?

I have recently been asked if it’s possible to have a data validation list on another sheet. Well, of course it is. This is particularly useful if there is a danger of your list being overwritten or erased, so sometimes its better to have it on a completely separate sheet. Let’s have a look at it step by step. Enter your data list into Excel.

How to force data validation in Excel worksheet?

For this purposes of this exercise, we will assume you called that range MyRange. Select the cell in which you want this drop-down list to appear and select Data » Validation.

Are there any drawbacks to data validation?

One drawback with data validation is that the moment you try to reference a list that resides on another worksheet, you will be told this is not possible. Luckily, you can make it possible by using this tutorial.

How to do external data validation in Excel?

In the Data Validation dialog, click Settings tab, and select List from the Allow drop down list, then enter =Country (Country is the name you have defined for the source range in step 2, you can change it as you want) the into the box of Source. See screenshot: 5. Click OK, now the external data validation has been created.