have a look at debra's site - there are some good examples you can download
that use advanced filter - copy that should help you.

one example:
http://www.contextures.com/AdvFilterRepFiltered.zip
--
jb


"dhermus" wrote:

From a master spreadsheet, I would like to break the rows out to
multiple worksheets based on matching criteria of two columns. As an
example, If column A = xxxx and column B = yyyy, the associated rows
would move to sheet1. Can anyone recommend the best method to
accomplish this?