Multiple Sheets to Multiple Books

[berg891832]

Okay,

I have one workbook called Payroll.xls. The book has three sheets - Jan, Feb, and Mar.

I want to export each sheet to it's own new workbook so each month will be its own file. Is there anyway I can do this with just one operation. I know I can do one at a time.

Thanks,
Bill

 

[Juan Pablo González]

No, you can't with just one operation.