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)