How to copy over only new rows

[DHero]

I have a report which I have to update from time to time. The combination (Concat) of the values from two columns is unique, so I have a "code" which identifies the row.
So, for the example: Sheet 1 has 1000 rows, Sheet 2 has 1200 (The previous 1000 are included in this) I want to copy over to the main sheet (Sheet 1) only the new 200 rows, all of which have "new" codes, problem is: They are all mixed. Is there a way to quickly do it? If a VBA code would be necessary I'm willing to adapt and incorporate it to the process.

 

[DHero]

 

[Joe4]

It would probably be helpful if you could post some small samples of your data so we can see what you are working with, what you are matching on, and what your desired results should look like.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[DHero]

Hey, unfortunately I can't use this Add-in, since the computer I'm working on is from the company and I can't install anything.
Anyway, I found the anser! Its on the video titled :

Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)​

What worked best for me was Method 3.