How can I use advanced filter and have it returns only
data that match what is in a cell. I use a listbox and
select a name, this name is referenced in the criteria
cell but it returns all data that looks like the criteria.

Can I reference a cell as a criteria in auto filter.

I use Excel 2000