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.
Bookmarks