Sortdeleteresort
or a macro to filter and delete the bunch or a loop such as

for each c in range("a2:a22")
if ucase(c)="OVERALL RESULT") then c.entirerow.delete
next c

--
Don Guillett
SalesAid Software

"Karen McKenzie" wrote in message
...
I have a spreadsheet that will have information pasted in daily from
another
source. How would I set code to automatically remove every occurance of
"Overall Result" from Column A. I know this is a worksheet change Event
Macro but I don't know the code to search in column A and remove these
entries.

Can anyone help?