AutoFilter Not Working
 

I am using Excel 2003 SP2

The Issue: I have a decent sized database which details vehicle makes,
models, class etc.

When I autofilter a column it isnt filtering the entire column.

For example, I filter for the Audi A3, but it is allowing everyting past row
40 to be on the sheet, but it should really only be one line with the
information on the Audi.

Any feedback would be great! Thanks!