I have read many of the threads that talk about setting up named ranges. That will not be an efficient way to do it for me.
I have a table with many combinations and I can see what I want when I auto-filter through the table column by column. I would rather not look at all the data as it filters. I would like to set the criteria that it is filtering by on the first page and each drop-down would be conditional. Like I said before, setting up named ranges would take too long and this is a dynamic table, so I would have to up the different ranges every time.
Is there any way to set it up like the following:
Sheet2, Row1 has all the fields that would do the filtering and below it, all the data to filter.
Can I copy Sheet2, Row1 to Sheet1 and filter from this page. Then, once filtered all the way down, cell C5 show a selected value from that combination?
Sorry if this is confusing. I am just trying to get it to where I dont see the table filtering, only the headers doing the filtering and then a value at the end.
I have a table with many combinations and I can see what I want when I auto-filter through the table column by column. I would rather not look at all the data as it filters. I would like to set the criteria that it is filtering by on the first page and each drop-down would be conditional. Like I said before, setting up named ranges would take too long and this is a dynamic table, so I would have to up the different ranges every time.
Is there any way to set it up like the following:
Sheet2, Row1 has all the fields that would do the filtering and below it, all the data to filter.
Can I copy Sheet2, Row1 to Sheet1 and filter from this page. Then, once filtered all the way down, cell C5 show a selected value from that combination?
Sorry if this is confusing. I am just trying to get it to where I dont see the table filtering, only the headers doing the filtering and then a value at the end.