Results 1 to 5 of 5

Thread: Automatic filtering in Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Automatic filtering in Excel

    Hello,

    I want to automatize a filtering of an Excel file but have no clue where to start from as I know nothing of Visual Basic...
    From 1 table I need to get 2 different summaries:
    1) filter column 2: 2 values to be removed. Then filter column 10: 3 values to be removed
    2) filter column 2: 2 values to be removed. Then filter column 8: 2 values to be left. Then only coulmns 1-2-8-11 should be displayed
    Anyone can help me? Hope it's clear...

    Thanks,
    RenNoClue

  2. #2
    Join Date
    Dec 2007
    Posts
    1,736

    Re: Automatic filtering in Excel

    If you're using an Excel Table, it has built-in filtering features. If your data is not in an Excel Table, follow these steps to add an Excel 2007 AutoFilter.
    1. Select a cell in the database.
    2. On the Excel Ribbon, click the Data tab, and then click Filter.

  3. #3
    Join Date
    Jan 2012
    Posts
    2

    Re: Automatic filtering in Excel

    Thanks James. However I do know how to filter an excel table, but I need an automatic Macro as I need to speed up the activity as it's a filtering which has to be done day after day and the people who has to do is not very computer literate...
    thanks

  4. #4
    Join Date
    May 2008
    Posts
    5,812

    Re: Automatic filtering in Excel

    There was a similar kind of topic made here already, it might help you out - Automatic filtering on Excel VBA and action button

  5. #5
    melonsmartin Guest

    Re: Automatic filtering in Excel

    To use automatic filtering, filter your data, choose Data> Filter> AutoFilter. Your column labels will be a drop-down menu. All the columns will be the only entry listed in the drop-down, together with all the top 10 choices ...... .... You can select Custom from the drop-down menu, select the column selection criteria.

Similar Threads

  1. Replies: 1
    Last Post: 25-01-2012, 06:27 PM
  2. How to Use Excel filtering to find data quickly
    By manishdk in forum Guides & Tutorials
    Replies: 1
    Last Post: 31-12-2009, 01:18 PM
  3. Automatic filtering on Excel VBA and action button
    By Happy46 in forum Software Development
    Replies: 3
    Last Post: 21-11-2009, 04:53 PM
  4. Excel autofilter stops filtering
    By roumieh2000 in forum Windows Software
    Replies: 3
    Last Post: 15-10-2009, 03:31 PM
  5. Sorting and filtering Microsoft Excel
    By CLONEOPS in forum Windows Software
    Replies: 2
    Last Post: 09-01-2009, 11:52 AM

Tags for this Thread

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
  •  
Page generated in 1,710,822,718.37497 seconds with 16 queries