Report

VbaHell

Well-known Member
Joined
Jan 30, 2011
Messages
1,208
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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

bamblack

Board Regular
Joined
Aug 15, 2011
Messages
208
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

Well-known Member
Joined
Jan 30, 2011
Messages
1,208
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,328
Members
414,054
Latest member
Sameer50

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top