Results 1 to 16 of 16

Conditionally Copy rows to new sheet in Excel 2007

Threaded View

  1. #1
    Registered User
    Join Date
    11-16-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    20

    Smile Conditionally Copy rows to new sheet in Excel 2007

    Hi,

    I am trying to write a VBA Macro for the attached template wherein the objective is to filter the rows based on the Month Column and copy them to new sheet.

    The number of rows and column can vary in the original file but the filtering criteria remains the same i.e. on Month.

    I want the rows to be copied to new sheets in the excel for each month.

    For example in the template, five rows have Jan-12 in month. I want them to be copied to new sheet called Jan12 and all five rows copied there. Similarly for Feb12 and so on.

    The number of sheets should automatically added based on months.

    Please help.

    Thanks in Advance

    Regards
    Paul
    Attached Files Attached Files
    Last edited by souvick; 11-16-2011 at 07:10 AM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1