Is it possible to make a living record?

[boingman7777]

I'm using my Excel to grab a web query of daily temperature, but it updates more than one time per day.

All I want it to do is take today's weather forecast, store it on another sheet and then do it again when the day changes.

Is this even possible to do?

Sorry if it's too complicated...

 

[Splith]

Not too hassle you but how exactly do you find data online that is easily transferable to an excel sheet. Automated of course.

 

[boingman7777]

i used a web query to pull a weather report from the farmer's almanac website...

still lost