Weather Forecast Spreadsheet

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.

You are right! I will attach the solution I got so far. It has been with the help of other users of forums including this one! Any input on how to improve it would be great! I am also looking to add to this a way for the user to give a custom name to the latitude/longitud combination. So for example, add a final column that for latitude/longitude 29.9857, -95.3324 it will say "IAH" for the respective rows. Then for latitude/longitude 21.332,-157.9198 it will say "HNL".

There are a few add-ins in AppSource that do this now. It will pull the data directly into your sheet for you. Just search AppSource for "weather in excel". I tried the Visual Crossing one and that did what I needed. Try a few out until you find what you need.