Hi, hopefully this will be an easy one for some of you! I've been playing around with it for a while but I'm still stumped.
As you can see, this macro first refreshes the pivot table. I want the macro to then delete the rows that have been eliminated from the pivot table (there is data beneath the pivot table, I want it to move upwards with the pivot table).
Please Login or Register to view this content.
The pivot table update works, but the rows for some reason are not deleted. Suggestions?