Hi Dear Friends,

I have attached a spreadsheet file, which has multiple sheets named-Harry, Steve, Thomas etc

I will need a technique where I can split this single file in to multiple files based on the worksheets within the original single master file. So once I have the split, I would like to the files to be named based on the names in the master file

example- Harry.xls, Steve.xls, Thomas.xls

This is just a sample file, I will have a huge number of worksheets (16 nos) in the master file and I occasionally do add and delete worksheets from the master file

Any help will be greatly appreciated

Thanks
Dumbo