You can use a list on a different sheet, if you name the list. There are
instructions he

http://www.contextures.com/xlDataVal01.html

gupt wrote:
i heard from someone that its possible to do the same thing without
using VBA. by using the Validate option in the Data menu and selecting
List in the options thr. i tried tht too. but i cant put the items i
want to put in the list in the same sheet and it only allows the source
of the list to be on the same sheet. so thats a problem. is it so or i'm
making a mistake somewhr? which one is a better solution?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html