VBA Check if combination of four cells is 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. 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 "results":
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]

Hi & welcome to the board.
A few questions.
1) Do you only have 4 columns of data, or are you trying to "Simplify" things?
2) Do you want to check all sheets in the workbook with the exception of the Results sheet?
3) Do you have a header in row 1 with data starting in row 2?
4) what sort of data do you have in the 4 columns?