Using Macro to separate a spreadsheet and create tabs for each month

**ajang** · 10-26-2012, 01:09 AM

Hi,

Can some please help, separating and creating tabs within a single spreadsheet based on month?

I actually download a full file which has months from Jan to June or sometimes Jan. to Dec. I have to separate and create different tabs for each month. I copy paste them manually (file attached). Is there a way to do it using Macro?

Thanxxx a lot in advance,
Ajang

**Armando Montes** · 10-26-2012, 01:21 AM

One way here:
http://www.contextures.com/AdvFilterRepFiltered.zip

**Trebor76** · 10-26-2012, 01:42 AM

Hi ajang,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

Using Macro to separate a spreadsheet and create tabs for each month

LinkBack

Thread Tools

Rate This Thread

Display

Using Macro to separate a spreadsheet and create tabs for each month

Re: Using Macro to separate a spreadsheet and create tabs for each month

Re: Using Macro to separate a spreadsheet and create tabs for each month

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions