Loop to copy paste pivot table data changing the filter every time and copy it

I have a strange one. I am looking to copy only the values from a pivot table into specific cells in another workbook, by changing the filter everytime. Here is my code so far, the copy part is out of my league and I am hopping that someone has an idea about this. Also, if the pivot for a filter choice is blank, can it be skipped?

Please Login or Register  to view this content.

Cross-post: https://www.excelforum.com/excel-pro...d-copy-it.html