View in details what filters are set

Brass Contributor

Hi all,

 

I suppose this is not possible, but it's worth the shot anyway.

 

I want to print a list after I set some filters, but I would like to see the used filters, so this is visible on the printed sheet.

 

So for example, when I print all orders of September and marked as finished I would like to see

 

Filters: Date=2022 | Status=finished

 

Is something like this possible?

3 Replies

@Celia9 

Not exactly what you ask, but see if you can use this: How to display / show auto filter criteria in Excel? 

Thanks Hans, this would add the filters, I just want to see (in text) what filters are activated.

I print the reports, and I want someone to replicate the filters from the hardcopy paper.

@Celia9 

The VBA function described in the link that I posted will display the filter criteria in cells.