Split the data into multiple excel Files based on the column Filters
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