split data into multiple workbooks with 3 conditions.

[malaionfun]

HI admin,

I require a macro file or coding to split data into multiple workbooks but with 3 conditions.

Ex column A to E have the below data.

A is supplier name
B is supplier's region
C is Currency
D is Product.
E is amount

Here I will have different suppliers who are from different region however there is a chance that supplier name could be same in different region. When the country changes the currency also would change. I would need a separate file for the suppliers who are from different regions even if their names are similar.

Hence I need a macro to create multiple workbook based on the filtering criterias below

Supplier Name
Supplier's Region
Currency

Hope you could help me.

Regards,
Malai

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA