Cell which displays the filter in use as text

Hi,
I have never seen this before so I don’t know if this is possible or not...

I require a formula that displays as text the filter criteria which has been applied to a data table.

For instance as an example in the attached I have applied the following filters:
Product:
Energikare and S4
Spacer:
Swiss
Thg/Ann:
Toughened and Annealed
Textured?:
Textured
Georgian:
Georgian and No Georgian

I would there like the following cells to display the following:
Cell C2: Energikare and S4
Cell C3: Swiss
Cell C4: Toughened and Annealed
Cell C5: Textured
Cell C6: Georgian and No Georgian

Basicallly, I would need the cell to display the name if the box is ticked from the drop down filter.
If all products are ticked I would like it to display All Products rather than EnergiKare and Laminated and Other and S4 and Tripple Glazed.

I have uploaded an example file, the formula is needed in the yellow cells.

Can anyone help please?

I am worried that this will get pushed down the list without a solution being found so I thought i best explain what I am trying to achieve...

I require the formaulas to display what filters are in place as this will be used for my chart title. If anyone has any other ideas how to do this please advise...

Hi,

@Arlu1201 I apprechiate it - I will be keen to see what you come up with.

@Shg, this may be the option I have to go down, I will wait to see what Arlu1201 comes back with first. I have done something simiar to this recently so I understand the logic - I would prefer a standard filter mind you but I am open to either method. Thanks for sharing the link

This is what I am after - does anyone know how I could adapt this macro so it wouldnt show in a message box but somewhere on the sheet? I would also like it so you didnt have to click the button to operate the macro if this is possible?

Can this part be expanded on so that rather than it display "Column A" (as in the code below) it displays the column headings e.g. Product, Spacer etc?

Please Login or Register  to view this content.

Hi,

Any luck Arlu1201?

The attachment in post #6 is modified to reflect your remarks.
Clicking the button remains necessary.