+ Reply to Thread
Results 1 to 1 of 1

Vba macro code for filtering based on two col years...

  1. #1
    Forum Contributor
    Join Date
    07-23-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    106

    Vba macro code for filtering based on two col years...

    Dear Excel forum Experts,

    Please help with this macro code, i need very urgently...

    looking forward for the positive reply...

    Thank You...

    In the attached file the first two cols is our area of interest. based on this only we need to do FILTERING process. FOR THIS I NEED MACRO CODE.

    The output must contain only the years less than April month of next year of season. To be more clear, if the season is 1971 and date is 22.12.1971 (same year) then it has to retained. if the season is 1972 and date is 12.04.1973 (next year) then this row has to be removed. likewise the rows above April month of next year has to be filtered.

    For your easy understanding I have done manually and attached the file. please find the attachment...
    Hope i am clear and not confusing. like this i have to do for 700 files.
    I need very urgently... Please do help me..

    Thank You,

    Regards,
    Dharani.
    Attached Files Attached Files
    Last edited by Dharani Suresh; 03-16-2014 at 02:28 PM. Reason: NEED URGENTLY... PLEASE HELP WITH THIS...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Please help to find a Macro to for filtering and sorting based on two criteria
    By 1Melina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2013, 12:54 PM
  2. [SOLVED] vba macro code for filtering from the given numbers
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-03-2013, 07:19 AM
  3. [SOLVED] Vba macro code for generating years along the side of days and also by removing the months
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-25-2013, 11:18 PM
  4. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  5. Need a vba code to check the status and based on rules calculate service years
    By baba_excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-19-2012, 09:03 PM

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