Put this formula in a cell row 2

=IF(A2={"Closed","Failed","Implemented","Imp(d)"}, "Copy","")

and copy down for all your records. Then use the Autofilter
(DataAutofilter), and filter on Copy, then just copy the visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pomalley" wrote in message
...
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.