I have created a drop down list . the validation data cell and the original
values are in different sheets,but on the same wirkbook. If I try to type in
new information that is not on the list it will give me an error message "The
value you entered is not valid". Is there a way to manually inpu information
in a drop down list?