Hi,

I have 2 worksheets with a lot of data in column B. The second worksheet is a copy of the first worksheet and is necessary to see the difference between the 2 worksheets. On the second worksheet an other user can add rows and insert new data in column B.
Afterwards a résumé should be made on a new worksheet. Therefore column B from the first worksheet is being copied to this new worksheet.
Now the tricky part.
A check should be made if the data in column B from the second worksheet also exists on the new résumé worksheet. If not, then it should be copied to the new résumé worksheet at the same place as it is on the second worksheet.
I only don't know how to do this. Can someone help me? Thanks in advance!