Filtere based on dropdown list?

[nithin89]

How do I get excel to filter data based on a selection from a drop down list?
I have a table which I want to be filtered based on the selection in the drop down list.


Any help appreciated
Thanks.

 

[dmt32]

Have a look at this site - they have plenty of working examples you can download for free.
File example FL0010 - Summarize Budget Details may be close to what you are looking for.
Sample Excel Spreadsheets - Excel Templates

Dave

 

[nithin89]

Thanks a lot![FONT=Arial, Helvetica, sans-serif][/FONT]It works exactly as I require.

 

[patrickteo91]

How about if creating the drop down list from the combo box ?