aravindhan_3
04-17-2016, 10:54 AM
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
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