Copy and Paste Row If Condition is Met

Hello,

Please help me with a macro that copies and pastes a row to another worksheet if a condition is met. Please see the attachment.

This is what I need the macro to do:

If Worksheet.FillOutThisForm.Range("E:E") contains the word "Sender", find the row in Worksheet.SendSide that contains the corresponding unique identifier in column L of Worksheet.FillOutThisForm. Then, copy the entire row from Worksheet.SendSide and paste in the next available row in Worksheet.Subjects.

If Worksheet.FillOutThisForm.Range("E:E") contains the word "Payee", find the row in Worksheet.Payside1 that contains the corresponding unique identifier in column L of Worksheet.FillOutThisForm. Then, copy and paste the entire row from Worksheet.SendSide and paste in the next available row in Worksheet.Subjects.

If Worksheet.FillOutThisForm.Range("E:E") contains the word "Both", then ignore that unique identifer and move on.

The range of data in WorkSheet.FillOutThisForm.Range("E:E") will vary.

Thank you for your help!

Mattman123

Thank you so much for your reply, arlu1201, and I apologize for bumping the thread. Yes- you were correct about the typo.

Upon implementing your code, I found two errors. First, for the first unique identifier "1234", it copied the row from both SendSide and PaySide, when it should just copy and paste the row from SendSide. In addition, it recopied and repasted the row for unique identifier 1234 from SendSide later.(Please see attached). Do you know why it might be doing this?

Nevermind, I was able to adjust. Thank you for your help!