It sounds like you want to use Dependent Lists.

See MVP Debra Dalgleish's website for instructions:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"jason2444" wrote:

want to creat custom drop down lists in as many cells as I choose in two
columns.
lets say A1 and B1. is there a way to make the list in B1 change depending
on what was selected in A1?