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