Macro to move worksheets from a workbook to a new workbook

**JNEWMAN** · 02-12-2016, 03:37 PM

Hi Forum
I'm guessing this is not Id doable in excel 2007 but I am new to macros and amazed at their capability, that's why I thought I would ask rather than writ it off. I have created a workbook that provides order planning but each order raised creates a new worksheet which will load the workbook size fairly quickly, is there any macro that would move worksheets at "Closed" status into new workbook with historical orders leaving space for new worksheets?

I may not be explaining this too well so feel free to ask questions..

Many thanks

JNEWMAN

**mehmetcik** · 02-12-2016, 08:09 PM

Easily done.

I would use a sheet specific macro to check the status of the worksheet.

Please Login or Register  to view this content.

If status changes to closed then the macro would call a second macro.

Please Login or Register  to view this content.

Macro to move worksheets from a workbook to a new workbook

LinkBack

Thread Tools

Rate This Thread

Display

Macro to move worksheets from a workbook to a new workbook

Re: Macro to move worksheets from a workbook to a new workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to create a workbook and copy or move worksheets in to workbook through loop

Save Copy of Macro Workbook as new Workbook with only Worksheets and values, Same Location

Move to next workbook if macro already run on current workbook

Creating macro to create 2 worksheets from a pivot table and move them to a new workbook

[SOLVED] Macro Wanted for looping thru worksheets in one workbook and pasting to another workbook!!

Cut and move data by macro (?) from one workbook to master workbook

Move worksheets to a new workbook

Bookmarks

Bookmarks

Posting Permissions