Comparing list from two different sheets and returning partial row if No Match

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

You have 3 sheets and it is not clear which one is sheet1 or WS4?

I assumed Current RMA is sheet1. I think the columns you want to copy are A-H, not G, otherwise the units will be omitted

Thank you so much! I will make sure I am more exact on what I need next time (correct naming of sheets and columns). This worked like a charm though!

loser420,
You are welcome!

Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.

AB33

One more question, Can I bring over the formatting as well as the values? I have some conditional formatting that I would like to see moved as well for easier viewing. If not I will just work on adding the formatting to the 'Repair Info' Sheet, it is just based off another cell in Current RMA that I am not copying over.

Thanks!