i want to compare 2 different excel sheets having column name same
capture1 image having rows 5 means ABCD.XLSX
Capture2 image having row 8 means EFGH.xlsx
In capture1 image, i want to compare column Name value abcd with column Names in different excel having value abcd so its Matched(capture2 image)
for next item in In capture1 image, i want to compare column Name value edfg with column Names in different excel having value abcd so its Not Matched(capture2 image), so it will check for another row in another excel sheet(capture2img), value is qqqq , so again its not matched
so it will check for another row in another excel sheet(capture2img), value is edfg , so its now matched