Is there a way to make separate Excel files for each worksheet short of using copy or save as?
P Patty Aug 6, 2004 #1 Is there a way to make separate Excel files for each worksheet short of using copy or save as?
J Jerry Eggleston Aug 6, 2004 #2 Patty, If you right click the sheet tab of the worksheet, you can click "mov or copy". Select that and then under the "to book" drop down list select new book. This will create a new workbook for you with onl that sheet inside. Hope this helps, Jerr
Patty, If you right click the sheet tab of the worksheet, you can click "mov or copy". Select that and then under the "to book" drop down list select new book. This will create a new workbook for you with onl that sheet inside. Hope this helps, Jerr
