You would probably find it easier to use an autofilter and then (if you needto)copy the visible rows to the other sheet.