Hi,

I have a worksheet with several drop down lists. List 1 determines what is available in list 2, list 2 dictates list 3. I want to have a fourth list, but the criteria for this list is also dependent on list 2 and when creating the validity, I am asked if I want to replace what is set up for list 3 - I don't! Is there a way to do this, or get around it?

Also, the options in each list are parts for sale, is there any way I can associate a cost with each of these (either in the drop down list, or in the table where the list is populated from) and display this in the adjacent cell, to be totaled later (this I can handle)

Thanks in advance for any advice
Ben