Hi,

I have a set of data in one sheet of an Excel workbook and I want to filter
the data using dropdown lists in another sheet. I was wondering whether it
is possible, when an autofilter is applied on the data, to have the filter
options visible and usable in another sheet in the form of a set dropdown
lists for each column?

Thanks