Split the data based on the column filters into multiple excel files

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