Hi. I will try to explain it as clear as i can. Let's say I have an spreadsheet with 2 tabs for old and new data. Both tabs are the same tables with same headings and formats but just different data values.
I want to know if the row in the tab with old data values containing say row value 1335XY is in the other tab with new data values. Is there a way of doing this? Also, I only want to compare specific columns not the whole row. Basically it would be validation against the old/new data if that makes sense.
I've attached an excel example which I hope helps. Thanks
I want to know if the row in the tab with old data values containing say row value 1335XY is in the other tab with new data values. Is there a way of doing this? Also, I only want to compare specific columns not the whole row. Basically it would be validation against the old/new data if that makes sense.
I've attached an excel example which I hope helps. Thanks