Multiple search criteria to filter value to a new sheet

chewjekhui

New Member
Joined
Aug 16, 2018
Messages
3
hi guys,

Need some help on a file that needs filtering though a drop down list.

Background: there are different quality of oil shipments that we are getting from the supplier vs the contracted quality that we agreed upon.

Every sample of oil is presented into a table called the crude oil quality assay
http://2.bp.blogspot.com/-jXx0FB2uZP...ight+Assay.bmp

Each supplier cargo shipment has one row of column of quality specifications. Meaning if let's say I have 5 cargo for month of June, I should have 5x row of the picture above, excluding the property row.

As the columns of data is fixed, I am tagging it with some attributes like the date of shipment, the supplier name and type of oil at each column of data

As the number of cargo and suppliers are plentiful, I want to hide the data source to the 2nd tab of data. I want the first tab to draw the data out based on the values i click on the drop down menu at the first tab (which is based on the 3 attributes date of shipment, supplier name and type of fuel) cascading effect

How do I go about doing that? I managed to do only the cascading drop down value. What is required to link the drop down to the data tab?

Fuel_quality.jpg


Cargo shipment quality

Fuel_quality_2.jpg
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

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
Back
Top