Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I move or copy more then one sheet at a time
I've got a Excel workbook with over 400 worksheets in it, I need to turn each
of them into thier own work book. Are there any shortcuts? |
#2
|
|||
|
|||
Ron de Bruin has a utility to do just that
http://www.rondebruin.nl/copy6.htm "Carl" wrote: I've got a Excel workbook with over 400 worksheets in it, I need to turn each of them into thier own work book. Are there any shortcuts? |
#3
|
|||
|
|||
Carl
Sub Make_New_Books() Dim w As Worksheet Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In ActiveWorkbook.Worksheets w.Copy ActiveWorkbook.SaveAs FileName:=ThisWorkbook.Path & "\" & w.Name ActiveWorkbook.Close Next w Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub If not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm In the meantime.......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord Dibben Excel MVP On Wed, 1 Jun 2005 23:54:02 -0700, "Carl" wrote: I've got a Excel workbook with over 400 worksheets in it, I need to turn each of them into thier own work book. Are there any shortcuts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
MACRO - copy rows based on value in column to another sheet | Excel Discussion (Misc queries) | |||
How do I copy an excel sheet with headers? | Excel Worksheet Functions | |||
copy a sheet in same workbook temporary block excel | Excel Worksheet Functions |