If cell value exists on another page, delete from main sheet.

[mystic_muffin]

Hey, Everyone;
I have a workbook that has a 'Job Input' worksheet and a 'job status' worksheet. I want to add a 'complete' button to the ends of the rows and the Job Status sheet that copies the row and pasts it to a 'Archive' worksheet. I then want that same macro to search the Job Input sheet and clear columns A-E if the value of A exists on that 'Archive' worksheet.
I have the copy/paste +1 row done... but I'm not sure how to proceed with the: If value exists in 'Completed' and 'JobInput' then clear cells A-E on job input.
Any help and explanation would be much appreciated!
Here is what I have so far:

[FONT='inherit']Sub MoveData[/FONT][/FONT]
[FONT='inherit']Range("b6:p6").Select     
Selection.Copy      
Sheets("COMPLETED").Select      
Range("A1").Select     
 Range("b" & Rows.Count).End(xlUp).Offset(1).Select 
ActiveSheet.Paste 
[/FONT][FONT='inherit'][FONT='inherit'] End Sub[/FONT][/FONT]