I have a workbook with 10 different work sheet. I would like to copy only one worksheet into a new workbook. I am using excel 2010. The sheet name is Trial. Only the records with a sheet name of "trail" should be copied. Rest should not be copied. The output workbook should be saved with the sheet name.
For example: Trail.xlsm.
I prefer the output to be saved in xlsm format.