Copy data from 2 worksheets and delete duplicates.

[mcontr01]

Hi, I am trying to do the following in VBA and cannot come close to getting it to work:

1. WS "Current Month" Find column with header "PROVIDER_CUSTOMER_NAME", then copy the data from row2 to the last row (the row range should come from column A)
2. Paste data on WS "MOM" (Month Over Month) starting in cell A3.
3. Then copy the same data from WS "Prior Month" by finding the same header "PROVIDER_CUSTOMER_NAME", t row2 to the last row (the row range should come from column A)
4. Past Prior Month data under the last of one pasted from "Current Month" on the WS "MOM".
5. select all pasted from both WS and delete duplicates.

Any help would be very appreciated!

 

[Saurabhj]

Hi, Is Provider_Customer_Name column is not fixed ?

Also, is the header on row number 1 in all three sheets ?

 

[mcontr01]

Hi, Is Provider_Customer_Name column is not fixed ?

Also, is the header on row number 1 in all three sheets ?

Hi Saurabhj, The header row is consistent on both Prior Month and Current Months sheets. They never change.