I have an excel file whose header is like this:
Business Unit | Customer Number | Transaction Number | URC | create date | id | customer name.
I am aware that the challenge is that the same Transaction could have multiple Customer Names (1 to many) and I am looking for a way to handle this.
I am interested that for each row in the excel file to check if the Customer Name matches the Customer Name displayed in the web pop-up (below attached). If there is a match: I want to click the hyperlink of the Transaction on its left.
For ex: if in the excel file Customer Name = ‘Grenke Renting S.A c/o Bom Sucesso’, I want to go through the entire pop-up and chose Transaction Number = ‘1806216’ on the same line with ‘Grenke Renting S.A c/o Bom Sucesso’, NOT on the same line with ‘AVE Bilisim’.
I tried both Screen Scraping and Data Scrapping but it didn’t identify the table correspondingly (it only identified first row of the table in the pop-up).
Any help would be very much appreciated.