Results 1 to 13 of 13

Filter data based on two variables(between two values)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    736

    Filter data based on two variables(between two values)

    Sir

    i am attaching here with my sample sheet in which i want to insert two button on which i which insert two codes:

    One-by name filter by dob
    second-by name filter by doj

    what i req is when i press filter by dob button it ask enter dob range dates(both inclusive)
    and i can enter there 1-08-1988:15-05-2003

    and by these range my entire sheet can be filtered/sort based on dob column-between these two values date data should be there

    similarly when i press filter by doj tab it aske enter doj range dates(both inclusive)
    and i can enter there 1-08-1990:15-05-2012

    and by these range my entire sheet can be filtered/sort based on doj column-between these two values date data should be there
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filter Data based on values in another workbook.
    By yoom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2013, 08:28 PM
  2. Summing values based on variables
    By giejack in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-10-2012, 01:02 PM
  3. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 PM
  4. Excel 2007 : Return all values based on 2 variables
    By Aggie81 in forum Excel General
    Replies: 3
    Last Post: 07-26-2010, 11:34 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