To insert a hyperlink in cells A3 to A1912 as done in the example attached Excel (cell A2)
The information resides on the following site, where webscraping might be applicable:
[login to view URL]
On the field “Código de Póliza”, if you input what is on column A, then the search will result in a document to download.
In my example of cell A2, if you input on the field “Codigo de Poliza”, the code POL120180098 and then search button (Consultar), then you will find the document to download (and the link to it). That link address is what needs to be inserted in the cell of the excel so when I click it takes me directly to the donwloaded document.
The idea is that the link to download the document is a hyperlink on column A for each respective record.
do not modify the other parts of the excel sheet. The deliverable is the same sheet but with each cell in column "A" containing the described hyperlink
Please first confirm you understand the task- or send me questions you might have.
17 freelancers are bidding on average $33 for this job
Hello, I can insert the correct hyperlink to all required cells in column A for you. I can start right now. Please open a chat with the so we can discuss more details. Kind regards, Sorin
I am Chirag Jakhariya, Over 5 years of experience with technologies like Web scraping, Data mining, WordPress, Magento, WooCommerce, Laravel and Custom crawler Development, PHP-Mysql Development.
I am happy to serve you my service in time. I am able to complete the job with full accuracy by taking good care also, which makes you satisfactory. Thanks!!!!