In the criteria cell, use a formula similar to the following:
="="&L1
where the item selected in the listbox is linked to cell L1
ANDRE ANDERSON wrote:
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.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html