|Let's review what you asked for in your OP:|
if the attribute can be found in sheet1 A:A then copy the entire row to sheet 3
1 - Do you see anything in that statement that give any indication that "the attribute" will be found more than once in Sheet1?
2 - You said "copy the entire row". Now you are asking that the row be cut and the blank row deleted.
Even if we give you the benefit of the doubt and call number 1 a mere misunderstanding, there can be no misunderstanding between the request to copy the row vs. the request to cut the row.
You are are now going to be subject to my canned lecture about changing the request mid-thread:
Don't take this the wrong way, but we often get questions in this forum where requirements come in drips and draps.
"I need a macro to this"
"Thanks, now can you make it do this too?"
"Hey, that's great. Now, how do I add this?"
That gets a bit annoying since we have to go back and modify the code, sometimes even rewriting it completely so we don't end up with inefficient, cobbled together code.
In addition, we (well, at least I) don't save every workbook that we set up to test our code. When additional requirements come along later, we (I) usually have to copy the code from the forum, set up the workbook with data in the correct columns, accounting for the new requirements, etc.
Since I don't want to just add lines to the code and post it without testing it, I have to go through extra (repeated) work to make sure it meets the new set of requirements.
Think about managing a project and asking someone to quote on it or even implement it. Once you start adding requirements after the initial work has begun, things get messy - and usually more expensive.
That said, I'll take a look at your new requirements and see what I can do - after I set up a new workbook, with data in the correct columns and copy the original code to the VBA editor.