retrieving data from websites

[khagnguy98]

Hi everyone

I have a small spreadsheet I am trying co compile, I've already had some previous help in here but I need a bit more


Firstly... I have used a power query to append my sheets which is exactly what I needed, but what do I do should the data change. How do I amend the query to update or do I just have to do it again?

Secondly. I am struggling to get one of my lists of contact email addresses and they are not published in one place. Each member of the group (Members of the House of Lords) has a profile BUT there email addresses are on a seperate page within their profile so in essence you have to click on each one and copy and paste.

Is there a way of doing this bearing in mind I've got a basic knowledge but I'm not that technically advanced. If I could solve these two things it will be job well done with help from this forum

Many Thanks

by khagnguy98

[bluesky63]

Hi khgnguy98

if you had previously established a link to the website in Power Query, and had done all the transformation to the required output (table) that you wanted, each time you just need to right-click and refresh will do

you can give us a mock up of what you are doing, stated what you want to acheive and the challenges (issues) that you are facing.