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!
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!