Compare and then merge 2 Excel documents

I need to compare 2 files containing products( [login to view URL] & [login to view URL]) , then merge them: a) Keeping the information that is the same on both (but JLS will have some columns already with data) b) Remove any rows (going by product ID) on JLS that do not appear on the supplier.csv. c) Add any rows (going by product ID) that do not appear on JLS but are on the [login to view URL] d) Update anything that is active or inactive on JLS going by the [login to view URL] Basically you are asking [login to view URL] file- does this product code exist on [login to view URL](yes, no)? If no then add to JLS if yes then leave. Then asking [login to view URL], do I have any product codes that are not on supplier.csv. (yes, no) if yes then remove from JLS. Then is this product active or inactive (on JLS).