Hi,
I am fairly new to this VBA stuff, and i am having difficulties with a pivot table(2) (sheet name = SP Check).
What i want it to do is to loop through the "Country" field, and for every country i want it to copy the content from this "SP Check" sheet and insert it the sheet "Budget" Cell A2 (ofc it needs to clear past content from the budget sheet first).
Once it has been copied into the Budget sheet, it should save the file as Budget Template - "country".
1. Change country
2. Copy/paste data
3. Save file
So the end result should be a file for each country
Does any of this make sense?
I am fairly new to this VBA stuff, and i am having difficulties with a pivot table(2) (sheet name = SP Check).
What i want it to do is to loop through the "Country" field, and for every country i want it to copy the content from this "SP Check" sheet and insert it the sheet "Budget" Cell A2 (ofc it needs to clear past content from the budget sheet first).
Once it has been copied into the Budget sheet, it should save the file as Budget Template - "country".
1. Change country
2. Copy/paste data
3. Save file
So the end result should be a file for each country
Does any of this make sense?