+ Reply to Thread
Results 1 to 3 of 3

Macro to Filter Copy the rows based on input

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

    Smile Macro to Filter Copy the rows based on input

    Hi,

    I am looking for help in writing a macro to filter copy the rows in excel and create new sheets. I have attached a template file for help.

    The excel can have data for n number of rows and from Column A:CF

    In cell B1, reporting month will be given as input in MM/DD/YYYY format. Once the data is input in cell B1, macro should match that data for every row in Column D and once Match found, it should create a new worksheet with Month name and paste all the rows for that month in the new sheet.

    Thanks in advance for help

    Regards
    Paul
    Attached Files Attached Files
    Last edited by souvick; 11-29-2011 at 04:45 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Macro to Filter Copy the rows based on input

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

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

    Re: Macro to Filter Copy the rows based on input

    Thanks Venkat,

    This works fine but I have two issues here:
    1. It doesn't copy the header row to the new sheet that I need
    2. On repeat run with same input month, ideally it should delete that month's exisitng sheet and recreate the output.Currently it is not able to handle that.

    Can you suggest something on this?

    Thanks and Regards
    Paul

+ Reply to Thread

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