Hi Alan:

This is an example of part of the sheet with items based on date of
requistion:

Item Code Item Description
BlkCart Black Cartridges
ColCart Coloured Cartridges
BlkCart Black Cartridges
ColCart Coloured Cartridges
BlkCart Black Cartridges
ColCart Coloured Cartridges
BlkCart Black Cartridges
BlkCart Black Cartridges
Nylon Balls of Nylon

If I filter for Black Cartridges, i get all the items but I also get Balls
of Nylon at the bottom of the filtered list. It appears as if the last item
in the list gets thrown in with the filtered data. As the ex. shows I only
have one entry for Nylon, but it does not show up in the AutoFilter drop-down
list. Neither does the (Blanks) and (NonBlanks) option. I selected the data
range first by just clinking in the headings for the data, then I tried again
by selecting the entire columns, and it still does not work.
There are no blanks within the data records, only the empty rows below.

I do have a couple VLOOKUP formulas and I add new entry either directly or
using a data form. I also have a couple macros to automatically open the
dataform and the filter.

Shereene

Thanks so much for taking the time.

"Alan Beban" wrote:

I can't reproduce your problem. Perhaps you could indicate it by
describing more fully what happens: i.e., the range to be filltered,
where the blanks are, where the unwanted data is, what you select, where
you add a new entry. You don't need to use the whole range if it's too
large; just enough to illustrate the problem.

Alan Beban