I wanted to compare excel file between today’s file and yesterday excel file. Column name will stay the same. From today’s excel file and I will match it with yesterday’s excel by using “Column 1” and if it’s match then I will copy the data from yesterday’s file from column 6 until column 9. If it does not found the match it will just skip the row.
For the above que you mean to say that
If the value of “A2” from Today’s Excel File matches with the value of “A2” from Yesterday’s Excel File then, the data From the Yesterdays Excel File starts from “F2” to “I2” should get write to Today’s Excel File Columns i.e from “F2” to “I2”
I just check on your solution and it actually doesn’t work correctly. But thank you for your effort on this.
Yesterday’s File
After I run the process and the result for today’s file:
Which as you can see supposedly row 5 of column 1 should have data in it and row 4 should not have any data since it doesn’t exist in yesterday’s file.