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
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.
- Select a cell in the database.
- On the Excel Ribbon, click the Data tab, and then click Filter.
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
Re: Automatic filtering in Excel
There was a similar kind of topic made here already, it might help you out - http://forums.techarena.in/software-...nt/1273790.htm
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.