Hi this is a project of data entry from a website.
First you go to the site which you see in the first picture.
There you type in the first three numbers of the era-code (look at the picture).
You will start with 904 and the second page of it, as you see in the picture.
Now you look for the entries on the second page which contain "Betriebswebseite besuchen". You copy and paste the data into the excel sheet like in the other picture. It's important that the homepage is formatted as a hyperlink!
Then you go ahead with the other entries that contain "Betriebswebseite besuchen" on the second page, then on the third and so on.
When you're finished with the 904 era-code you go ahead with 905, 906, 907 and so on.
When you finished 909 you start with 910 and go ahead to 911, 912, 913... until 919 and so on.
The same procedure must be done until 979.
When you have all websites collected I need you to look if the websites contain on any side the words "Beleuchtung" or "Licht". If so, you will type in a "y" or a "yes". When not, just skip it. I'm pretty sure you can handle this with VBA.
This is a medium range of work. Because many zip codes doesn't exist