Write a macro to compare the columns B in HPMP & HPH Products.xlsx and Saleable Part list.xlsx and highlight the difference in the HPMP & HPH Products.xlsx. Only column B in HPMP & HPH Products.xlsx sheet "parts" will be compared to column B on Saleable Part list.xlsx sheet "Saleable Part". If one part number appear on "HPMP & HPH Products.xlsx sheet "parts" " but not on Saleable Part list.xlsx sheet "Saleable Part" then highlight said part number on the HPMP & HPH Products.xlsx Only.
please help, Thank you!
please help, Thank you!