Macro to savecopyAs multiply based on filter

[aravindhan_3]

Hi,

I have file with a tab called "Master data" and other 5 tabs. In Master tab I have country wise sales data ( 60 Countries- country column is D) ,

Now I want to make a copy of the same file 60 times for each country, so that each file will have only that countries data.
if I have to do this manually, I go to master tab > select column D, filter "Not equal" to "India" and delete all rows , Save as "India- Master File", close the activeworkbook > again open my master file repeat for 2nd country till I complete 60 countries.

Can someone help me with the macro to automate this? I can create a list of countries in sheet 3 so that we loop through.

Regards
Arvind

[p45cal]

deleted

[aravindhan_3]

Hi sorry P45, I didn't get this, "Deleted"

Regards
Arvind

[p45cal]

I deleted my post.