Results 1 to 3 of 3

Macro to Filter Copy the rows based on input

Threaded View

  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.

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