Edit existing VBA to remove duplicates and include conditional?

I'm new to VBA and would appreciate help modifying this code. I'm using the code below in the workbook attached. It removes duplicates in Sheet1 and copies values located in Sheet1B&C into Sheet2A&B. The problem is when it copies the data over it creates a ton of duplicates in Sheet2. I need to modify the code to only copy over data from Sheet1B&C to Sheet2A&B if it's not already located in Sheet2 e.g. if the data in Sheet1B3&C3 are already located in Sheet2A&B as a pair in the same row it DOESN'T need to be copied over. I need to eliminate duplicate values in A&B of Sheet2; only unique values should remain.

I need the data I'm copying from Sheet1 to be copied over as pairs of data in the same row e.g. A2&B2, A3&B3. If duplicates ever appear in Sheet2 they need to be deleted based on whether or not there's data in D and/or C of the same row. If there's data in C and/or D I need the duplicate without data in C and/or D to be deleted.

I then need to include a conditional format that highlights and row A:D in Sheet2 if C and/or D is blank.

Please Login or Register  to view this content.

0SAMPLE.xlsm

Margy,
Your request is not clear to me.
You are trying to remove duplicates in sheet1 and then copy them in to sheet2 and then you want to compare them with sheet2?
Do these two exist before you apply the code? Or is sheet2 is created from sheet1?
Do you want to compare both sheets based on two columns(Dept and Size) and copy the rows which are match on both sheets with out duplicates?