Excel: Pulling Weather into Excel Spreadsheet??

Discussion in 'Mac Apps and Mac App Store' started by olletsocmit, Oct 21, 2010.

  1. olletsocmit macrumors 6502

    olletsocmit

    Joined:
    Jun 24, 2010
    Location:
    USA
    #1
    I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!

    Any help would be greatly appreciated!! It would be nice to get some sleep tonight and not stay up all night again working on this.

    Thanks guys!!
     

Share This Page