Pulling Multiple Results by Matching one variable from List of Variables

Hi, I am working with an index/match/min function in which I can input a value from a data list and pull all data with that value and their corresponding information. I am trying to do this with a large data set and I'd like to be able to pull all data without actually having to change the input cell value -- an example excel file is attached.

For example, if I update the tab "data sheet" I want it to automatically pull and display ALL info that match all of the values like short lists:

Code: Quantity: Type:
1 850 a
1 879 b
1 871 c
1 356 c
2 109 b
2 7 b
3 860 c
3 786 a
3 541 a
3 963 b
and so on.....

Currently I have to manually change the Input Cell if I want to view the different sets of data.

Thanks! Let me know if I need to clarify anything.

You can try the code below. Just an FYI. I tried to put the code in Worksheet_Change module, but it kept crashing, so I reassign the code to a button. You might need to click the button everytime when you change the input cell.

Please Login or Register  to view this content.

Never mind. DoEvent Fixed it.

Please Login or Register  to view this content.

Try this,

In D7 with Just ENTER, then copy down

Please Login or Register  to view this content.

In E7, with CTRL+SHIFT+ENTER,

Please Login or Register  to view this content.

Then copy this to F7, then select D7:F7 drag down.