http://www.contextures.com/xlautofilter02.html
--
David Biddulph

"Abas Ibrahimov" wrote in message
...
Dear friends,
I need more than 1000 unique entries in the drop down-list while using
Autofilter feature of Excel. But I have lists that contain lots of data.
Is
there any way to increase unique entries? Thanks beforehand. Any help will
be
appreciated.
Abas