Hi All, need help regarding the use case below,
Basically below is my excel file data.
In the ID column, I have to consider the repeated values as one record and have to copy the corresponding columns and get their receipt date, receipt no and receipt amount to check against the PDF file using screen scraping.
For ex, ID 900003 appears 3 times here and I have consider the 3 rows as one record, I need to get the corresponding receipt data, receipt no and amount to cross verify against the PDF file and if there are matches I have to update the record as matched and verified. After that I have to move to ID 900004 and so on and so forth. Can you give an idea on how to achieve this?