My spreadsheet contains more than 3000 records. I want to retrieve only
those records whose status is Closed, Failed, Implemented, or Imp(d); Status
is Column B in the worksheet. Once I identify those records, I want to
automatically copy them to another spreadsheet. I do not want any blank
rows, only the records that meet the criteria. Any suggestions, please
advise. Thank you in advance for your help.