Hi Cris,

with drop down list boxes containing the same values as in the
autofilter criteriers.

make a "copy" of your data with an advanced filter (set to unique values),
load this list into your drop down.

arno