Macro to split one file into many based on criteria !!!

**gamefreak** · 07-08-2015, 12:20 PM

Hi ,

I need a macro which can split my data based on the countries in the dump in to diffrent country files. the countries will be present in 3 tabs .

I have pasted the Column headers i need split it based on the D Column 'Country' , it shud keep all the data pertaining to the country & should delete rest of the other country data & same the file in the country name . Kindly help me with this macro

all the 3 tabs will have the same data sets but for different months

File is in XLXS

but the headers would remain the same

Period Client Client Name Country Client Group Domicile Region Segment GAM ID (FAM ID) GAM Name (FAM Name) MPR Product XSell Mapping YTD Annualized Revenue Total Revenue

Regards
Vatson

**gamefreak** · 07-09-2015, 11:24 AM

Hi ,

Any help on this ?????

Regards
vatson

**jaslake** · 07-11-2015, 05:15 PM

Hi Vatson

Your Sample File has 4 Worksheets (the 4th is blank). Will your Actual Data Files have only three Worksheets?

Do you want a separate Workbook for each Country? Will these Country Workbooks be cumulative or should they be cleared the next time you split the Data File?