method to split data rows to multiple worksheets.

[dhermus]

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?

 

[john]

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