Multiple Worksheet Change Events

Thanks JB. I tried your code; it's more elegant, but still doesn't get me there. I've posted a sample workbook so you can see what I'm facing.

I hadn't thought about turning off the autofilter, but you're probably right about that. The way it would work for my users is that each one is responsible for one Division, so that would be the first level to look at. However, they would also want to be able to narrow down that view and look at specific Program Codes within that Division. That's what I'm aiming at. Thanks in advance for any help you can throw my way.

John

Marcol,

I couldn't get to your example: for some reason our firewall sometimes blocks zipped files, and sometimes doesn't. Today's one of those days.

i tried the code you posted, but didn't make any other changes. The code seems like it wants to work, but there's issues;

What I want (way it should work): both autofilters/Change Events work in tandem. User selects his/her division, then the PAC they want within that division. They may look at 2-3 different PACs, one after the other, all within the same division, or they may want to compare a PAC in their division with one in someone else's. So, the two autofilter's need to work together.

With your code, it seems I can choose Division, and PAC, but when I choose another PAC or division I get mixed results.

Thanks,
john

Further clarification; the autofilters should always be active, and should always change according to what's currently in E1 and E2, so if EITHER change, only the affected Auftfilter should change. So, if I change E2, the U autofilter should change to the new value, the T autofilter should retain the last value it had (the current value of E1). If I should change E1, the T autofilter should change to the new value, the U autofilter should retain the last value it had.

Further clarification; the autofilters should always be active, and should always change according to what's currently in E1 and.......

Okay that was probably what was throwing me.

Can't look at it just now, I'll look back later and if your problem is not solved I'll give it another go.

Thanks Marcol, I'm about to leave for the day, so if you think of a solution I'll be eager to see it when i come back. Thanks so much to you and JB for working with me on this. I really appreciate it.

Okay, I got three attempts at a solution while I was away, and none of them are working as intended. Here are my results:

JB, using your solution on both my example and my source sheet, the filter works on column I and H instead of T and U. Any ideas of what I'm doing wrong?

Marcol,
Your example appears to do an either/or instead of a both. For instance, if I filter for Division 513, I get all the PACs for 513. When I then also select FBI Disproportionaility Staff, I get that PAC for ALL Divisions, not just for 513.

SNB,
Your example looks cool; I like the Dependent Dropdowns. But choosing anything doesn't seem to affect the autofilters at all, no view changes.

I appreciate all your help. I'll keep plugging away on my end to see if I can get any of your solutions to work, but I'd sure like to find a solution fast. My boss wants to present this today, and I hate that I'm stuck on what should be a simple thing. Any help you can give is very welcome.

Thanks,
John

JB,

I'm getting a syntax error on these lines:

Please Login or Register  to view this content.

JB, Sorry. I figured that out AFTER I'd tried the code. I'm working with it now, and so far it seems to be doing the trick.

Marcol,
Your latest example still has issues. I selected Division 510, which populated correctly with the Div 510 PACs. I then chose the "Brotherhood Initiative" PAC, which should have shown just that PAC for Div 510. Instead it changed to showing all Division and PACs.

Bad hair day. I forgot to save the changes before posting.

I have changed the attachment in post #16 rather than post again, no point in leaving errors on the board.

Have another look at the attachment there.

Sorry for taking so long to get back to you. I went with JB's code for now (easier to implement), but I like Marcol's dependent validation dropdowns, so may change in the future. Thanks so much for all your help on this issue.

Merry Christmas!

John