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

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

goayimm wrote:
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
Contextures
http://www.contextures.com/tiptech.html