I extracted a table data and set an auto-save in excel file.
In the next step, I would like to add 2 new columns in the excel file (indicated in red) and extract 2 types of information from the same website.
To get those information, I need to click the company name one by one
And 2 screen captures below are the 2 types of information I would like to add onto the worksheet.
(Only the first LeadUnderwriter)
(extract the first 5 sentences)
Could anyone give me advice what activities to use?