I have workbook1 column b that contains shipping numbers and I need to compare it to workbook2 column c which also has shipping numbers. Basically we are trying to ensure that the shipping numbers in workbook1 column b are contained in workbook2 column c and match exactly. If not, then we need to see what is missing. We generate workbook2 and our customer sends us workbook1. We'd like to find a way to automate this as much as possible as it will need to be done several times a week with changing data. Thanks.