split data into multiple workbooks with 3 conditions.

[malaionfun]

Hi admin,

Please find the attached sample report as requested.

I have given the sample data in the tab one and tab 2 is the output in the format I required.

The split file should be segregated with the below criteria

1. Country
2. Payment/Recovery
3. Currency

For Example, spain have both debit and credit with two different currency namely GBP and EUR.

I require the separate file for each criteria, a file can contain line items of Spain, debit, GBP and new file for Spain,Debit,EUR.

Hope this helps.

Thanks and regards,
Malaionfun

malaionfun,

Welcome to ExcelFox Community.

It would be best to upload a sample workbook that represent the layout and structure of your original workbook, so that developers here can understand the input viz a viz the output.

Regards,
Sam

Sample report.xlsSample report.xls