Private Sub Worksheet_Change(ByVal Target As Range) Help

[adamsj1]

Dear All,

I really would appreciate some help on this. I have been trying to figure out something to work for weeks. so we have a bunch of different product qualities that we sell to different regions of the world. And we can only deliver some qualities to one customer and differnt qualities to another. I want to be able to see this on one page which i designed in the below work sheet based on dependent list. I decribed in notes what I am looking to do on the attached worksheet. Any help would mean a lot.

Thanks and kind regards,

Adamsj1