PDA

View Full Version : macro to savecopyAs multiply based on filter



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

p45cal
04-17-2016, 03:09 PM
deleted

aravindhan_3
04-17-2016, 10:58 PM
Hi sorry P45, I didn't get this, "Deleted"

Regards
Arvind

p45cal
04-18-2016, 01:40 AM
I deleted my post.