Hi Antony,

Try using the Advanced Filter feature rather than the AutoFilter.


---
Regards,
Norman



"Juno" wrote in message
...
Hi All

My macro automatically runs autofilter and filters data with every filter
criteria I have set and moves them to separate sheets. But I want the
macro
to automatically identify all the filter criteria in a given column and
filter out the data in separate sheets. I tried my best to find if excel
offers any such feature so that I can convert into a macro. But I could
not
find any. If anybody can give any lead in this direction, it would be of
immense help.

Regards
Antony Juno