VBA Marco To Copy Sheet to New Workbook

**TexasBobcat** · 07-20-2018, 04:26 PM

Excel Gurus,

I am curious to learn about a VBA loop code that will allow my sheets in a workbook to each be individually moved and saved into a new workbook. The name of the workbook will be the name of the tab.
My workbook has about 179 tabs that need to be moved and saved. I am hoping to find a way to save me some time.

Where should I start first?

**Fluff13** · 07-20-2018, 04:34 PM

Try

Please Login or Register  to view this content.

EDIT
Added the line in blue to close the new workbooks

VBA Marco To Copy Sheet to New Workbook

LinkBack

Thread Tools

Rate This Thread

Display

VBA Marco To Copy Sheet to New Workbook

Re: VBA Marco To Copy Sheet to New Workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Marco to update sheet first and then copy

Copy HTM Files from Closed Workbook and Copy to Active Workbook if Sheet Name=File Name

[SOLVED] Copy sheet from another workbook based on ComboBox names of the Workbook and sheet

[SOLVED] macro to copy rows from a sheet in one workbook to a sheet in a different workbook...

Marco to copy some filtered date on one sheet to another sheet in the same shared workbook

[SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions