Hi,
I would like to create a process that looks like this.
There is an Excel sheet with a column containing different company names. These company names will be used to search for their respective companies on the website http://www.allabolag.se/ (a website containing different company information).
When the company itself has been sought, some information is retrieved from the website (For example, to see how the website looks like searching for a company, you can enter 556012-5790 in the search field and press enter).
First of all, the numbers given to the left of the text âturnoverâ. Then the text âKey numbers 20xx-xxâ will be retrieved; here there should also be an âifâ rate saying that if it says 2017-12, the data table should be specified as âNot brokenâ, and if it is not 2017-12, the data table is specified as âbrokenâ.
The idea is that the new information should be used to create a new data table where a column A should consist of the company name, column B should consist of sales and column C, âbrokenâ or ânot brokenâ should be given depending on the if rate.
The new data table should then be saved.
Any ideas on how to do this?
Many thanks in advance!