Multiple Sheets Filtered By Dropdown

[Redlad91]

Hi All,

I am looking for some help, I am trying to filter the overall results that i receive on my spreadsheet by a drop down filter. I currently have two separate spreadsheets, One has all my data and the other is an application i am trying to build to analyse data depending on the criteria in 3 cells.

So in this we will call Sheet 1 Data and sheet 2 Application.

On the application document i have four boxes as below;

Cell C3 - Name: (Drop Down)

Cell C5 - Day: (manually enter what i want to search in box)

Cell C7 - TimeManually enter what i want to search in box)

On the Data document i have the following tabs Julie, Jack, John, Peter, Alison.

What I want to do is select a name from the drop down list in Cell C3, and then this will narrow down anything that is on that named sheet, so when i enter text in cells C5 and C7 this will only show results/count any data which is from that sheet.

Apologies if that doesn't make sense or you want it explaining more, Just let me know and i will try to explain it better.

Thanks.

 

[crazydragon84]

i don't think i follow. do you mean you have sheets that contains data which are named Julie, Jack, John, Peter, Alison, and if you select from those name drop downs in C3 of your application worksheet, then it refers just to the data on the respective tab? You can use the indirect function on your C5 and C7 dropdown to use the value in C3, if that helps.

 

[Redlad91]

Hi, these are two different workbooks which are named data and application, within the data workbook I have different tabs along the bottom with these names.

I want to link the cell in the application workbook to the different tabs in the data workbook.

Do you have any examples of the indirect function I could try?