Legacial
06-28-2011, 06:28 AM
Hi guys.
So I have 2 excel files that contain similar fields. Thing is there is some data that each worksheet has that the other doesn't. I want to differentiate the data based on the following fields - document_number, coupon_number and document_class where:
1. coupon_number is either 1,2,3,4,11,12,13 or 14
2. document_class is either PAQ,NOS or GED
3. document_number is of a wide range: 20,000 - 2,000,000,000
I want a macro that can get the missing document_numbers from each worksheet that is not present in the other worksheet based on the doc_class and coupon_no and displays this data in a separate worksheet, for example, lets say I display document_numbers in worksheet 1 that aren't present in worksheet 2 and that are of doc_class PAQ and coupon_number 3.
Is this possible?? Any help would be deeply appreciated. Thank you!!:)
So I have 2 excel files that contain similar fields. Thing is there is some data that each worksheet has that the other doesn't. I want to differentiate the data based on the following fields - document_number, coupon_number and document_class where:
1. coupon_number is either 1,2,3,4,11,12,13 or 14
2. document_class is either PAQ,NOS or GED
3. document_number is of a wide range: 20,000 - 2,000,000,000
I want a macro that can get the missing document_numbers from each worksheet that is not present in the other worksheet based on the doc_class and coupon_no and displays this data in a separate worksheet, for example, lets say I display document_numbers in worksheet 1 that aren't present in worksheet 2 and that are of doc_class PAQ and coupon_number 3.
Is this possible?? Any help would be deeply appreciated. Thank you!!:)