I have a report where I'm breaking down by one large category and then by a sub category. So for example, the large category would be Car Makers with selections Honda, Toyota and Ford. And the sub category would be models under the major catgories (Honda would display Civic, Accord, Odyssey; Toyota would have Camry, Sienna, Rav-4; etc.)
I've been able to link the dropdown boxes no problem.
However, I want these two selections to drive multiple pivot table report filters. I do have VBA that would take the large category and drive a single report filter on multiple pivot tables.
My first choice was to concatenate the two cells into a single reference like "Honda Civic" and then use the code I have, but that sent the VBA into an infinite loop which I could only break by quitting excel.
Is there a way I can write some code that would allow me to drive two separate report filters from mutiple dropdown boxes?
Thanks!
I've been able to link the dropdown boxes no problem.
However, I want these two selections to drive multiple pivot table report filters. I do have VBA that would take the large category and drive a single report filter on multiple pivot tables.
My first choice was to concatenate the two cells into a single reference like "Honda Civic" and then use the code I have, but that sent the VBA into an infinite loop which I could only break by quitting excel.
Is there a way I can write some code that would allow me to drive two separate report filters from mutiple dropdown boxes?
Thanks!