Split the data into multiple excel Files based on the column Filters

[RanjanKT]

Hi All,

I am quite new to the excel VBA. I wanted to split the data based on the column Filters and saved into multiple sheets.

Below are the sample data.

I wanted to split the Data based on the below conditions.

1."Americas" Filtered for HQ & Inbound(in the column) then
A."Canada" filter=HQ & Inbound- save as Canada File.
B."FSO Americas"=HQ & Inbound- save as FSO Americas File.


2."EMEIA" Filtered for HQ & Inbound then
A."Africa" filter=HQ & Inbound- save as Africa File.
B."CESA" =HQ & Inbound- save as CESA File.
C."EGP"=HQ & Inbound- save as EGP File.


3."Asia-pacific" Filtered for HQ & Inbound then
A."ASEAN" filter=HQ & Inbound- save as ASEAN File.
B."FSO APAC" =HQ & Inbound- save as FSO APAC File.
C."Greter China"=HQ & Inbound- save as Greater China File.

Kindly let me know if this can be done usin the VBA



Fund Name
Americas
Canada
FSO Americas
EMEIA
Africa
CESA
EGP
Asia-Pacific
ASEAN
FSO APAC
Greater China


ABC
0
HQ
0
HQ
Inbound
HQ
Inbound
Inbound
0
0
HQ


ABC
0
HQ
0
HQ
Inbound
HQ
Inbound
Inbound
0
0
HQ


ABC
0
HQ
0
HQ
Inbound
HQ
Inbound
Inbound
0
0
HQ


ABC
0
HQ
0
HQ
0
HQ
Inbound
Inbound
0
Inbound
HQ


ABC
0
HQ
HQ
HQ
0
HQ
Inbound
Inbound
HQ
Inbound
HQ


BCD
HQ
0
HQ
Inbound
HQ
HQ
Inbound
Inbound
HQ
Inbound
0


BCD
HQ
0
HQ
Inbound
HQ
HQ
0
Inbound
HQ
Inbound
0


BCD
HQ
0
HQ
Inbound
HQ
HQ
0
HQ
HQ
Inbound
0


BCD
HQ
Inbound
HQ
Inbound
HQ
0
0
HQ
HQ
Inbound
Inbound


BCD
HQ
Inbound
0
Inbound
HQ
0
0
HQ
0
0
Inbound


BCD
HQ
Inbound
0
Inbound
0
0
0
HQ
0
0
Inbound


BCD
HQ
0
0
Inbound
0
0
HQ
HQ
0
0
0


XYZ
Inbound
HQ
Inbound
0
Inbound
0
HQ
HQ
Inbound
0
HQ


XYZ
Inbound
HQ
0
0
0
0
HQ
0
0
HQ
HQ


XYZ
Inbound
HQ
0
0
0
Inbound
HQ
0
0
HQ
HQ


XYZ
Inbound
0
0
0
0
Inbound
0
0
0
HQ
0


XYZ
Inbound
0
0
0
0
Inbound
0
0
0
HQ
0