I'm trying to use Validation on Sheet 1 to create a list. The data for the
list is on Sheet 2.

I've assigned the name "States" to the column on Sheet 2 that contains the
data for the list.

On Sheet 1, when using Validation for the list, when I enter "=States" in
the Source box, it says "A named range you specified cannot be found".

I tried entering = and then clicking on the tab for Sheet 2 but it won't let
me do that.

I'm probably missing something really simple.

Thanks in advance.