Filter A Pivot Table Multiple Times Based On Values In List In Another Sheet

First off thanks a Million. You guys have saved me 100 times over!

I want to batch filter a pivot table with values from a separate sheet.

Maybe I could set variables like Var1 = A1 in Sheet1, Var2 = A2 in Sheet one etc... My problem is I don't know how to tell the macro to stop. If the next Var is Blank then end?

Thanks in advance!

Please Login or Register  to view this content.

Hi,

Hope below codes will help you.

Please Login or Register  to view this content.

regards
taps

Thanks. I'll test and get back to you!

This worked?!?!?!

Hi w.m. christensen,

Not able to understand what you are saying. Is it working?

regards
taps