weather

  1. N

    Web Scraping

    Hello, I need help trying to get the 1st line of the following 10-day forecast. Here is my code to get the forecast for Miami, FL on Weather.com. I am not able to get the current date or the first date in the summary. Please help. Thanks and take care. Sub MiamiWeather() Dim ieObj As...
  2. D

    Sumproduct

    Been having hard time solving this question.I got it wrong and i believe the workings used is the cause of it. Question 1 The following file describes the situation faced by a landscaping company, 'Landscaping Solutions'. If there is great weather, the company takes the following hours to...
  3. W

    Read/import online weather data into an excel sheet.

    He Guys, I am trying to read/import(actuel) weather data into an excel sheet. So i surfed the web for quite some time, but i am hoping you can help me out. I have some experience with vba, but not with reading data into excel. So i will explain what my idea is, I want to read/import actuel...
  4. L

    Creating a line graph that shows the relationship between my business's takings and the weather

    Hi, I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner. I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship...
  5. C

    Instring Search to Return whole Line

    Hi There, I have all text in a cell example Cell A1 Today is hot Last week was cold Today's weather is 18 Next week is 20 I need a VBA code that searches the cell via instring search for example searches "Today's weather" and will return the whole line "Today's weather is 18" which then i will...
  6. A

    Weather Information into Excel using Openweather API Filterxml Webservice

    hi Need help with the following; it is clearly beyond me ! I have an API for openweather.org I can Paste the API info into a Browser and get a response back that looks like this; Webinfo...
  7. R

    web image installed inside a cell

    I have an excel file I use to make my daily task sheet. I wanted to have it include the daily weather forecast with the weather icon, the high and the low. I have worked on some of how to make this work but I'm hitting a road block getting the image to download into the correct locations. I...
  8. R

    NOAA NWS data into PowerPivot

    Has anyone successfully brought in Noaa NWS XML data into powerpivot ? National Digital Forecast Database XML/SOAP Service - NOAA's National Weather Service NOAA's National Weather Service National Digital Forecast Database XML/SOAP Service - NOAA's National Weather Service i can get the SOAP...
  9. A

    Weather

    Hi, I am trying to incorporate a Weather forecast into an excel sheet. Is there any code that can do this? thanks
  10. L

    Complex Web Query Help

    Hello, Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks). I found a website which has this info: http://www.wunderground.com/history/ and I can put in a...
  11. J

    Weather data

    Hi I used wolverineb’s formula http://www.mrexcel.com/forum/showthread.php?t=458054&highlight=wind+direction) in reverse to calculate the wind direction in degrees from wind direction in text. The lookup table is This works well after a little tweaking. The formula I am using is...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top