See http://www.contextures.com/xlDataVal03.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Wendy" <Wendy @discussions.microsoft.com wrote in message
...
I have figured out how to get drop downs in my spreadsheet but I can not
figure out how to be able to re-use the same one in different boxes over
again. When I put in a selection from a drop down, it takes it away from
being one of the choices on my list for the next one. I hope someone can
help! I am very frustrated!