Data Validation is the way to go, use it regularily.

Ensure that you list criteria of what must appear on the pull down is
somewhere on your sheet, I have yet to find a way where I can have a master
sheet with all my detail.

"Debra Dalgleish" wrote:

> You can use Data Validation to create dropdown lists in cells. There are
> instructions in Excel's Help, and here:
>
> http://www.contextures.com/xlDataVal01.html
>
>
> ghost1967 wrote:
> > Is there a way to make a custom dropdown list for a column or group of cells?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>