--I am trying to understand what I am doing wrong. I selected the entire
column C in worksheet 1 for my validation entry test. The Data validation
references the list of valid account numbers shown below, which is a range
contained in worksheet2:
10400
12200
21010
26716
29000
29037
The validation is set to reference account numbers from the above list (the
range is set up as the entire column B where this list occurs, though the
list is only 40 or so account numbers, the entire column is referenced in
case I want to add additional account numbers to the approved list at a later
date). The Data Validation tab is activated to stop and show the error alert
after an invalid entry. (I want to limit the user to selecting only those
accounts on the validation list).

My problem is when I test it, it seems to accept any account number I enter
in Cell C1 in worksheet1, without regard to the actual accounts I have set up
on my data validation list in Column B in worksheet2. There is no error
message that comes up when I enter the invalid account number, just a drop
down box that allows me to enter any number I wish. What am I doing
wrong???Any help greatly appreciated!

DakotaSteve