I am having one excel i.e. Name is Master.xlsx which contains the Id and Category. Another excel i.e. Name is - Test.xlsx, contains the Id column.
I wanted to compare the Id from Master excel which Id from Test excel. If Id matches then update Category column from Master excel in Categery column of Test excel againest maching Id.
How I can acheive this. What is the best way. If each file having 1000 records for comparision then how we can do this ?