How do I save multiple worksheets as individual documents?

bgirl24 · Sep 14, 2009

I have a workbook which is split into numerous worksheets. Is there an easy
way to save a copy of each worksheet individually?

Pete_UK · Sep 14, 2009

Ron de Bruin shows how that can be done, here:

http://www.rondebruin.nl/copy6.htm

Hope this helps.

Pete

Saving worksheets within workbooks as individual files	4	May 10, 2006
Master Worksheets and Individual Worksheets	1	Apr 2, 2009
Compare multiple rows for duplicated values in individual columns	1	Feb 21, 2009
How do I move multiple tabs in multiple workbooks to a master?	3	Oct 9, 2009
How do I find like data in multiple worksheets?	1	Nov 4, 2009
autofilters on worksheets within workbook	4	May 18, 2009
Can you save each sheet in a workbook separately?	2	Jul 28, 2009
Save worksheets to different files	3	May 2, 2005

Ask a Question