Hi, My req is to match compare the cell value, Cell headers name and number of columns will be always same.
I want to compare like A2 of one sheet with A2 value of another. and likewise for B2,C2,D2 and E2 also.
Note. My excel files name will be dynamic only.
Once compare the cell value I want to write the status to another cell Match/Unmatch for each cell value.
@Palaniyappan @Lahiru.Fernando I approached this method, but doesn’t work, bcz I am opening the updatesheet excel for updating the each invoice data, so it corrupt the file,