how can i automate copying of tabs to a new workbook?

E

emme

I have a workbook has the same tabs every month and each month I need to
parse out the tabs in the same way to separate workbooks. Is there a way to
automate this?

As an example, let's say my workbook has 10 tabs labeled tab1 to tab10.
Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook,
etc.

I don't know VBA at all, can anyone help?
 
E

emme

thank you. is there a way to copy only certain tabs? i need to parse out to
several separate workbooks. how would i modyify your code?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel function to get tab name 9
Need a macro to copy & delete data 5
how do i automate parsing a workbook 4
Create a list of pre-named tabs 2
Copy/Paste from one workbook to another not recognized by formulas 2
Excel Compare numbers on 1 tab to other tabs in workbook. 1
Is it possible - find all of a named range? 3
Counting across tabs 1

Top