I am trying to create lists; however, if one picks from one list, then the
other list to pick from is contingent on the first list

Debra covers "dependent lists" at her:
http://www.contextures.com/xlDataVal02.html
Excel -- Data Validation -- Create Dependent Lists
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---