Inverse / Reverse of the filtered items

[nabeelzz]

good day all,

i need some macro to show me the reverse of current applied filter.
For example

i have a table and one column in table shows Dep A, Dep B, Dep C, Dep D etc.
i apply filter on this column for Dep A and Dep C..... So Dep B and Dec D will be hidden.
From here, i need a macro which will show me Dep B and Dep D which were previously filtered out (hide/filter out Dep A and Dep C).

Assume i have a lot of departments then its a pain to go back and see the inverse of what you previously filtered.

But that's not completely it.

Further, assume that i have applied a filter in Col A and then applied further filter in Col C. Now i want to see the reverse of applied filter for Col C only, not for Col A. Col A's applied filter should be intact.

Saying it another way, that i would like to invert the applied filter for the column in which i select a cell, but not touch other applied filters in Columns other than the selected cell.

i hope i explained myself properly.

Any help is much appreciated.

 

[Fluff]

Glad to help & thanks for the feebdack

 

[PankajMaheshwari]

Hi @Fluff I read all the comments and it seems to be working for others. But for me, I getting and error and when I click on debug, it's taking me to below line:

With Ws.AutoFilter.Filters.item(ActiveCell.Column)

My file in not macro enabled. I have pasted my code in personal macrobook in a module.

Can you please help me. Meanwhile I'll try something from my end.