Data Mapping - Macro

Hello,

I have a system that generates a report in an excel file that has two columns “Services” and “Product” however the services against the product are not correctly mapped. Hence, I need a macro to map the correct service against the product. The reason I am looking for a macro code is because I already have macro which does the preflighting part and this code will be an extension to that.

I have added two tables below 1) The data I get from the report and 2) Correct Mapping

1) The data that I get from the report:

Services | Product
===== | ==========
EDD | Hosting
PO | Processing
DS | Forensics
PO | Collections
PO | Data Management
EDD | Staffing & Resourcing
EDD | Consulting
MDR | Compliance
EDD | Due Diligence
PO | Intellectual Property
PO | Service and KM


2) Services should be mapped as per the table below:

Services | Product
==== | ==========
EDD | Hosting
EDD | Processing
EDD | Forensics
EDD | Collections
PO | Data Management
PO | Staffing & Resourcing
PO | Consulting
MDR | Compliance
MDR | Due Diligence
LDR | Intellectual Property
LDR | Service and KM

If someone can help me, then that will be great. Thank you in advance.