You have two worksheets...

Autofilters won't react to changes like this.

In fact, if you only had one worksheet and used data|filter|autofilter, then
changed a value right in that range, you'd have to reapply your criteria.



Pec1909 wrote:

I have two work books , data, datatype.
Data has column B as datatype, which is populated either 1 or 0 .
Datatype has an autofilter on column A (all 1). Cell
A2=if(data!b2=1,data!b1,"")

This works fine, until I modify the value in data!b2 and then change to
workbook datatype. It will still display Data!b2 data even if it is conflicts
with autofilter.

Question: How do i get the filter to auto update beween workbooks?
--
Everyone one wants to go to heven, but no one wants to die ;-) (Curits
Mayfield)

--

Dave Peterson