Is there a way of comparing 2 sheets with similar data but where the data is in a different order.
What the problem is I have two worksheets.
The first sheet (see attachment sheet1) is how the data downloads off our main system. The second sheet (see attachment sheet2) is a form that is made for manual entry and so has some rows that are headings and also some products are sparated off because of the product type.
This means that even though the data in the 2 columns in each sheet should be the same they will appear in different cell references.
what I need the program to do is 1) check column B in sheet 1 to column B in sheet 2 and highlight any value in sheet 1 that doesn't appear in sheet 2.
2) check column B in sheet 2 to column B in sheet 1 and highlight any value in sheet 2 that doesn't appear in sheet 1.
3) A bit more more complicated. check the value in column B in sheet 1 to the value in column B in sheet 2 then lookup the value in column A of both to make sure they match and highlight the cell in column A in either sheet if they don't.
There are diffences in the example.
Is any of this possible as all the programs I have come accross so far only compare exact cell reference matches?
Bookmarks