Hello,
autofilter in excel only show the first 1000 entry/rows in a worksheet.
thats why you dont see all the data when drop down the autofilter.
You may visit http://www.contextures.com/xlautofilter02.html to further
infos how to solve this problem


--
bhararatax
------------------------------------------------------------------------
bhararatax's Profile: http://www.excelforum.com/member.php...o&userid=34111
View this thread: http://www.excelforum.com/showthread...hreadid=536601