Find out applied filter column name

[Pinang]

Hi,

I daily get big file from my team which contains 500 columns, I want to find out in which column filter has applied. I am trying this manually but it takes lots of time to find out.

Please help.

Thanks in advance!
Pinang

 

[NARAYANK991]

Hi Pinang ,

If you can use VBA , check out this link :

http://superuser.com/questions/436667/show-excel-column-filter-information-in-cells

Narayan