Is there a way to take a workbook and copy each worksheet to its ow
workbook.

IE: Workbook 1: Sheet A, Sheet B and Sheet C

Would like:
Workbook 2: A copy of 'Sheet A'
Workbook 3: A copy of 'Sheet B'
Workbook 4: A copy of 'Sheet C'

Thanks :-)

Hillar

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com