I tried following the instructions on that site (http://www.contextures.com/xlDataVal05.html) exactly. Actually, I had looked at that site before.

When I try and create the drop down list, using the exact same names and sheets as in the example, I get an erroe message saying that "The source currently evaluates to an error. Do you wish to continue?"

I am reproducing the example (I think) exactly. If I say "Continue" the drop down cells are blank.

I am mystified.

Thanks again for any help.

Allen