filtered info can be copied (extracted) to seperate sheet

[Fam via OfficeKB.com]

Hi,
is there is possibility to extracted drop down filtered info list to a
seperate sheet?
any help will be appreciated.
thx Fam

 

[Debra Dalgleish]

You can copy and paste the filtered data to another sheet, manually or
programmatically.
Or, use an Advanced Filter, starting on the destination sheet. There are
instructions here:

http://www.contextures.com/xladvfilter01.html