Hi ,

I am working on one excel which has 5 different sheets .Named as below

RECAP -1008 & 1021
RECAP- 1017
RECAP- 1063
RECAP- 1131
AR Statement

I am looking out for a macro which will create 4 excels with one excel.

1) 1st excel should have two sheets = RECAP -1008 & 1021 & AR Statement
2) 2nd excel should have two sheets = RECAP- 1017 & AR Statement
3) 3rd excel should have two sheets = RECAP- 1063 & AR Statement
4) 4th excel should have two sheets = RECAP- 1131 & AR Statement

Basically my “AR statement sheet “ is common in all the excels .

My one more requirement is each sheet should save in a particulate folder . All 1st sheets should save in folder name “1008 & 1021” , 2nd should save on folder “1017” , 3rd in “1063” and 4th in 1131

Is it possible to do this job with macro .I have attached format file for reference.