HI admin,

I require a similar kind of macro to split data into multiple workbooks but with 3 conditions.

Ex column A to E have the data.

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

Here in A 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

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

Supplier Name
Supplier's Region
Currency

Hope you could help me.

Regards,
Malai