Private Sub Worksheet_Change(ByVal Target As Range) Help

**adamsj1** · 10-26-2012, 09:41 PM

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

**BeachRock** · 10-27-2012, 12:00 AM

Hi Adamsj1,

It looks like you need dynamic cascading menus to accomplish what you want to do.

Take a look at this: http://www.exceltip.com/show_tip/Exc...m)_/30065.html

I use them in a project I built and they are great.

**jeffreybrown** · 10-27-2012, 10:31 AM

See if this is what you had in mind...

**adamsj1** · 10-27-2012, 08:02 PM

Hi Jeff,

Thanks so much that is what I've been looking for for weeks now. The last thing I was wondering is it possible to dispay only the rows that apply. i.e. if Europe contract 1 has 17 qualities that apply only show rows 10 to 27 and for example Europe contract 2 has 10 qualities that apply so dispay rows 10-20. I have seen this macro before but cant seem to make it work. The reason is some contracts I can sell up to 50 qualities and others only 2 qualities. This would really make it great. I appreciate the help so much.

Thanks and kind regards,

Adamsj1

**adamsj1** · 10-27-2012, 08:15 PM

I attached the file with comment and better explanation to what I would like to accomplish. I really appreciate your help and have already started applying to formula you created ans is working great.

Very much appreciate your assistance.

Adamj1