Macro combination of cells already included in range

[swbine]

Hello,

currently I'm working on a tool which will include some macros. I got several sheets with information about articles in columns A-D. All rows should be checked whether this combination of cells Ax-Dx is already included in range xy in sheet "result" or not. If not, the row should be added.

I tried Application.Match, but this only seems to work with one-dimensional arrays. As far as I understand, other methods I found on the internet only search for cells, not combination of cells (e.g. .Find?). Can someone help me with an advice?

Example:

Sheet 1:
A B C D
1 2 3 5
2 4 6 8
3 1 6 5

Sheet 2:
A B C D
1 2 3 5
2 8 6 1
3 1 6 5
4 2 1 3

Sheet_Copy:
A B C D
1 2 3 5
2 4 6 8
3 1 6 5
2 8 6 1
4 2 1 3

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...cells-already-included-range.html#post4999331

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.