Can someone assist me, please?
I am looking for a macro that searches down column A for
one of the following criteria cuts and copies the criteria
to column D and puts -1 to -5 in its place.

CRITERIA REPLACED WITH

AQC STANDARD -1
AQC DUPLICATE -2
AQC SPIKE -3
AQC DIFFERENCE -4
LOG DIFFERENCE -5

None of the other information in column A must be copied
to column D only rows that fit the criteria.

Thank you

Jan