Data copy paste loop

Hi There

I am fairly new to the world of excel vb, was wondering if you could provide some help please. From the attached spreadsheet, I have a pivot table. What I like to do, via vb, is be able to select every item from the I:1, pivot table dropdown filter, one at a time and loop through, every time value changes in I:1, updates the pivot and copy range H3:I12, then paste to another workbook TEST "SHEET1". Loop back to attached file filter B:3, copy paste same range and paste to another workbook TEST "SHEET2" and so on so forth.

Please can some one help.


Many thanks

There is no attached file.

Also you can just create a pivot for each filter item.
http://www.pivot-table.com/2012/10/2...ch-pivot-item/

Did you click on my link that shows you how to automatically do it with the native functionality?

You would have to write code to do specifically what you want.

I am on my phone, which is why I typically suggest the easy method.
Plus you can ask google for examples.