Mr Ramesh, I think the filter drop down list has a limitiation of 1000 entries in excel 2003 which might be extended to a bigger number in excel 2007.
Again the dropdowns are re-populated when filter is set on a column. For example, I filtered on 'Customer No' column for Nov-10, it got out 'deposit date' drop down values '1-nov-2010'. What is understand is: When, working with filter in a workbook (excel 2003) having more than 1000 rows, if the criterias in a particular column also exceeds 1000 (like deposit date), then it is better to break it into two columns. Break the Deposit date into two columns, ie Deposit Month and Deposit Date. For filtering on a particular date, first filter on particular month and then select the date. Regards, Kishan Reddy, K . On Nov 7, 7:44 pm, Ramkesh Maurya <sunscel...@gmail.com> wrote: > Dear all, > > I am facing a problem in filter (in column N) when I use Excel 2003. > > There is a date 1-Nov-2010 which is not appearing in the Auto Filter option > although when I deleted blank cell but this is appearing when i sorted in > asc/descind order > > In Excel 2007 this is appearing. > I have attached the file. Thanks for any suggestion > > -- > > Ramkesh > 9990260398 > > PDC TRACKER - SOUTH.zip > 2274KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
