Splitting files into multiple workbooks on the basis of specific column

Dear All,

I have excel data file where the code can split the data into different xls file on the basis of country for first sheet only.

Require your help to execute the code so as to create single country wise files for all sheets. i.e. file consisting of data with sheet A1,B1,C1. The present code works only for sheet A1 and it creates different files with data related to that country. I was looking for the output file with B1 and C1 as well for that country. Also new output file needs to be renamed just as of original one.

Sample file attached

Regards,

Manwatkar

Thank you Sir..

I was also looking for sheets B1,C1 or even more sheets (if available) where similar data is available. Output file should also consist of these sheets data..Also, can it be posible to rename the output file sheets simlar to original one.

Regards..