View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
emme emme is offline
external usenet poster
 
Posts: 5
Default how can i automate copying of tabs to a new workbook?

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?