Hi
no, advanced filter won't update automatically. You have to rerun the
filter.
Maybe a nice addin for this:
http://www.rondebruin.nl/easyfilter.htm
--
Regards
Frank Kabel
Frankfurt, Germany
"lintan" schrieb im Newsbeitrag
...
Thanks for your help. Would advanced filters update Sheet 2 if I
add/update
information in Sheet 1.
"Peo Sjoblom" wrote:
Select the range and do datafilteradvanced filte, select copy to
another
location and unique records only
Regards,
Peo Sjoblom
"lintan" wrote:
My list has several material that can be used for different activites.
What
would be the best way to display the material with each unique
activities?
For discussion purposes, in Sheet 1
Material Activity
Thinner Thinning
Thinner Equipment Cleaning
Primer Metal Coating
Primer Wood Coating
Thinner Thinning
Primer Metal Coating
Enamel Metal Coating
Enamel Wood Coating
Therefore in Sheet 2, a table with two columns will contain the
following
information:
Material Activity
Thinner Thinning
Thinner Equipment Cleaning
Primer Metal Coating
Primer Wood Coating
Enamel Wood Coating
Enamel Metal Coating