See Debra's article on dynamic validation:

http://www.contextures.com/xldataval02.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MA" wrote:

I want to create a drop down list where the variables change depending on
what has been selected in a previous cell. I can create lists, but am not
sure how to make the second list change based on the previous entry