Macro that will compare data in columns and give results

Hi All,

Good day.
I have here a file which will be populated by thousands of customers.

Column B C D and E will be the data extracted in the system.

Column K and L will be the given value for us to compare with the extracted data from the system.

When i click the RUN Button:

So for Column N, it will show "YES" if the customers in column B exist in column K and "NO" if not.

For Column O, it will show "YES" if the customers in column D is THE SAME in column L and "NO" if not.

For COLUMN T, it will check if the data from column K is duplicated.


For COLUMN V AND W, data from COLUMN B and C will be copied.

COLUMN X will be from the requested value for the customer and not from extract. Meaning it will match the the customer number and will show the value from column L.


For Column Y an Z, it will be coming from column E and column F.


Thank you guys in advance~ badly need this file since we are using formula it makes the file slower and slower.