Advanced filter to another sheet
 

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

Advanced filter to another sheet
 

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