Hi there,

I'm new to VBA, so I apologize if this is basic. I have a dropdown pivot table filter (cell B8) with a number of options and want to return the data that populates in cells G21 and H21 for each dropdown option. Is there an easy way to do this?

Thanks!

Alex