Automatic filtering in Excel

[RenNoClue]

Sponsored Links

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

[JAMES_911]

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.

[RenNoClue]

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

[Simond]

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

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.