Online update from a web-site

Hi there,

Just two days ago I created a topic and it was solved just in two min. Now I have another question related to the first topic but in a different level.

I run a report of 1000 companies every week. I take it from a web-site by copying names. Every week I copy a list of 1000 names and compare them in attached excel with the last week list. Basically is a comparison of two list to see new companies that got into the list. As you will see excel sheet takes the each name in the 2nd list, search it in the first list and if it is a new company type in G column NEW. For companies from 1st list that don't show up in 2nd list types OUT in A column. Also it shows changes of rankings with arrows. This is exactly what I need, new companies in 2nd list and the ones that went out.

My question; is it possible to take this names directly from the web-site ? Because if I can get this, I would run daily reports and check all companies every morning and would save almost half of my day.

If someone can come up with a solution we can talk about details, web-site and etc.

Thank you very much beforehand.

Sincerely.

Gokhan

Main Excel.xlsx