Advanced filter to another sheet

[goayimm]

I'm trying to filter a list following to fulfill a few criteria. Although I
could use Advanced filter but however i couldn't filter it to another sheet
in the same workbook. Any other suggestion how I could do it so that data
could be automatically updated from the first sheet, if it change?

I couldn't seems to be able to use microsoft queries in the same workbook too.

please advice.

Thanks

 

[Debra Dalgleish]

You can extract the data to another worksheet if you start the filter
from the destination sheet.

There are instructions here:
http://www.contextures.com/xladvfilter01.html#ExtractWs