OK, I have a basic spreedsheet and I created a drop down list (yes, no
and NA) i did the data... validation and linked it to the cells but i
can't figure out how to link it to cells on another sheet from the same
spreadsheet? when i go and choose my cells it won't let me hit the
other worksheet that i want to refer to? I am I doing this backwards?

here is what i have in data...validation...source field =$N$22:$N$26
TIA,
Greg