I need to compare 2 spreadsheets that are coming form different sources but have mainly the same content. I can easily edit them so that the columns are in the same positions in both but I need to know how to compare each column of one spresheet to the corresponding one on the other.
Basically, to compare things such as stock codes, barcodes and price to make sure they are all the same on both sheets. One list will contain items that the other does not.
I need it to return items that do not match
Appreciate any help on tis