How to dinamic cell that searches for "value1 & value2" in table.

A

armindo

Hi

I have an excell sheet with columns city and comercename i would like to
make a dinamic cell that searches for city=Lisbon & comercename=cars and it
would search the entire database and crate an output with all entries witch
respected city=lisbon and comercename=cars. How to?
 
A

armindo

Auto filter does not change when the variable chnges, i need a dynamic cell
not a pontual situation
 
D

Dave Peterson

Maybe you could use a combination of Data|filter|autofilter (or
data|filter|advancedfilter) and a worksheet event that did the work when you
typed something into those two cells.
 
Top