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

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?

Hi

Have a look at Data/Filter/Autofilter.


--
Andy.


"armindo" wrote in message
...
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?

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

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.



armindo wrote:

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

--

Dave Peterson