This above link is similar to what I am looking for, but it would not work in my SS. Here is what I am looking to do. (I have very little VB/Macro experience)

1. Compare Column G of Worksheet 1 to column G of WS 4
2. If there is a Match, Do nothing
3. If there is NO Match, return columns A-G of WS1 to the next empty row in WS 4

Any help with this would be much appreciated! I have found numerous scripts on this forum, but none seem to do what I would like. I have one macro in the worksheet that will do a complete copy of all the data in columns A-G, but it does not check for matches and copies everything everytime!

Thanks Again!
TEST.xlsm