To fetch data from sheet 2 based on the selections made on sheet 1

[maryflower]

Hello experts,

This might sound complicated to me, but I am sure its a piece of cake for you

I have a spreadsheet, with two tabs on it.

One tab - "main' has all data with lot of information. Kind of source data.
Another tab - "results" where I would like to fetch from "main" tab based on the criteria selected on this tab

Attached the sample file and the desired results I am looking for.

On the "main" tab, column B is always unique. Based on the selections made on "Results" tab, I want a macro to pick up the data in column B of "main" tab.

If the selections made has 10 data on column B, I would like to see all 10 data.
If selection reads "All", I would like to see all data on Column B with no filters
If selections are made, but there is no data for selected criteria, I would like to see " No results"

I have mentioned everything in the attached file as well.
Any help is appreciated.


Thank you very much!
maryflower

[dflak]

Try using a pivot table as shown in Columns P-Q in the attached.

[maryflower]

Hello dflak

Thanks for your response. Sorry, my mistake I didn't mention this before. The goal is to achieve this without pivot. I currently have pivot.
Sorry again for missing this important piece.