+ Reply to Thread
Results 1 to 9 of 9

Filter data using dropdown list options

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,287

    Filter data using dropdown list options

    I am using a GUI as pic attached to display details stored in a range (data2) on worksheet called data. Drop down list of names displays relevant data.

    The view buttons at the bottom are macros that view the accident/incident part of the file and will filter the data to show only the accidents for the driver listed. It filters for entries of that name in 1 column and instances of accident in anoth column.

    The filter ranges are shown right of GUI

    I have been asked to create a button macro that will display in the data worksheet only the names that have a safepass/hazchem/manual handling. There would be an entry in the form of an expiry date.

    I have tried adapting the macros used to filter the list worksheet

    Please Login or Register  to view this content.
    crit equals t2:u3 (top one of listed ranges)

    Any help appreciated
    Attached Files Attached Files
    Last edited by nigelog; 11-01-2010 at 12:40 PM. Reason: title change

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: data filter macro

    Please post a workbook rather than a picture.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: data filter macro

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,287

    Re: data filter macro

    had to clean workbook of info - posted in original post now, many thanks

  5. #5
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: data filter macro

    Sorry but your file is a little confusing! Do you mean you want to filter the Data sheet for entries in col U, W or Y?

  6. #6
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,287

    Re: data filter macro

    Quote Originally Posted by StephenR View Post
    Sorry but your file is a little confusing! Do you mean you want to filter the Data sheet for entries in col U, W or Y?
    there is a dropdown list next to VIEW DETAILED LISTING with 3 options. When an option is chosen I need it to open and just display the details of the drivers with an entry in those columns you have mentioned.
    rgds
    Last edited by nigelog; 10-29-2010 at 12:30 PM.

  7. #7
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,287

    Re: data filter macro

    question unanswered so far so I will try to clarify


    in the attached file is a worksheet called GUI which is the "front end" of a system for reording and reporting on accidents/incidents. It also stores data relevant to the drivers of these vehicles.

    THe three "VIEW" buttons at the lower RHS filter the data in the "FILE" worksheet to show the number of occurances attributed to the named driver. These use a macro referencing a "filter range" which can be seen on top left of GUI worksheet.

    I have been asked to also filter the "DATA" worksheet using a dropdown list VIEW DETAILED LISTING refering to specific licences the driver may hold

    I have tried repeating the "filter range" macro that does work for the "FILE" worksheet but I cannot get the macro to filter the the via the columns U W or Y if there is an entry in there for the driver

    any help appreciated rgds nigel
    Attached Files Attached Files
    Last edited by nigelog; 11-01-2010 at 06:04 AM.

  8. #8
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,287

    Re: data filter macro

    Have worked out how to filter data in one instance (bit heath robinson) using a range filter

    range=data2
    range criteria=licence

    not what I need though - any ideas for getting the same results as the filter for Manual Handling for the other 2 options in the drop down list without having 3 seperate macros

    Working file attached
    Attached Files Attached Files

  9. #9
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,287

    Re: Filter data using dropdown list options

    not answered - bump

+ 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