Macro to Paste Entire Row from 1 worksheet to another worksheet using a condition

This code does exactly what i want except for instead of copying the entire Row over to the 2nd worksheet, it copies just one cell value over. I need the entire row to copy over instead of just the 1 cell value. Everything else works how i need it to. It is the Copy code towards the bottom that I am struggling to figure out how to update to bring EntireRow over instead of the 1 cell value. Any help would be great. Thanks

Please Login or Register  to view this content.