I have an excel which have 2 sheets, I need to compare both sheet data and need to write the mismatched data in a new sheet in the same excel.
I am comparing the data by taking as all the columns as primary key, and the column names and number of columns in both the sheets are not same. It is not getting executed in such a way.
Can anybody help how can I take 1 or 2 columns as primary key column to compare the data.
Please find the attached FYI.
CheckDuplicates.zip (12.4 KB)