Autofilter dropdowns

[Guest]

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

 

[Guest]

no, you can't have the dropdowns on another sheet. they are always placed at
the top of the filtered data.

You can put dropdown boxes on another sheet and populate them with a unique
list (which you will have to build), then when a selection is made, have your
code set the same selection in the appropriate autofilter column. Then
adjust all your dropdowns to reflect the restricted lists which will now be
in the autofilter dropdowns. (again, you will have to develop those lists
with your code).

 

[Guest]

That's what I thought. Thanks.

no, you can't have the dropdowns on another sheet. they are always placed at
the top of the filtered data.

You can put dropdown boxes on another sheet and populate them with a unique
list (which you will have to build), then when a selection is made, have your
code set the same selection in the appropriate autofilter column. Then
adjust all your dropdowns to reflect the restricted lists which will now be
in the autofilter dropdowns. (again, you will have to develop those lists
with your code).