I have a data set with 10 fields, from the data set, I need to produce 5
separate list from 5 fileds in the data set which eliminiates all the
duplicates, are there any way where I can re-produce the list of variables in
the auto filter drop-down to another location? Or can I re-locate the "auto
filter buttom" to another worksheet?