There are three sheets in this workbook. The column’s names are the same on all sheets. For example, these are A-B-C-D columns.

The data in column C of a sheet will be compared to the information in column C of the other two sheets. If the same information is available, the information in column A and column B will be look the same. A-B-C names is added to a new page. If the matching information is two, two information of the match or three, three info of the match is automatically added to D columns on the new sheet. There are about 200,000 rows in each sheet. A, B Text C, D Number format.


Sheet1:
A B C D
Info1 Info2 Info3 Info4
Info1 Info2 Info5 Info6
Info15 Info16 Info17 Info18

Sheet2:
A B C D
Info1 Info2 Info3 Info8
Info1 Info2 Info6 Info10
Info7 Info9 Info3 Info11
Info15 Info16 Info17 Info19


Sheet3:
A B C D
Info1 Info2 Info5 Info14
Info1 Info2 Info12 Info13
Info15 Info16 Info17 Info20



The new sheet will be automatically in the following.

A B C D1 D2 D3
Info1 Info2 Info3 Info4 Info8
Info1 Info2 Info5 Info6 Info14
Info15 Info16 Info17 Info18 Info19 Info20

Thanks,
Alime Yüksel

Attached Files

Problem.docx (14.2 KB, 10 views)