Hello all! For the past couple of years every friday I have been manually passing weather forecast information into an excel spreadsheet to plan out my week.

Now I recently heard about the wonders of VBA and I'm wondering how could I pass the information for 7 days ahead if it's actually possible!

I have been using accuweather and metoffice.gov.uk for the forecast, I find they are pretty accurate. I tried a web query but it's not allowing me to take it as a table. Here's the link.

http://www.accuweather.com/en/us/hou...197?view=table
http://www.metoffice.gov.uk/public/w...orld/9vk4qr24r

Any ideas? Or if any of you know of any tabular forecast websites that allow the web query that would be great!

Thank you in advance.