Report

[VbaHell]

Hello one and all
I am using Excel 2007 and if possible require some help


I have multiple columns with data and I am trying to complete a filtering report.

Column A has a product group
Column B has product sets
Column C has Origin codes


If I select a product group I just see every in the whole sheet relating to the product group slected
I then want to further reduce this report by selecting a products set.
Then reduce again by selecting a origin code and so on.

This way I can interigate all the information in different filters

I hope I have explained this

Is this possible please

 

[bamblack]

Turn AutoFiltering on.

In your Data tab click on filtering. This puts a dropdown box on each header. It's pretty self-explanatory from there.

 

[VbaHell]

Thank you for this.

is it possible to have the filter drop downs on a header page and only show certain answers, like values, margin that all pull from the main data