Help scraping data from webpage into a sheet based on date

Could you attach the code with a sample excel book?

Click on GO ADVANCED, scroll down and click Manage Attachments.

The data on the website updates daily so I want to be able to open the file, run the VBA and have it pull in the latest elevation (301.42 or whatever the new level is) into the upstream (A6) and the downstream into A7 based on if the dates match from what the server gives me "Current pool (EL): 301.42 (m) at 11/23/2016 21:20"

You have a single date in row 8, so there can only be a single date to match. Row 8 does not a time. Have you tried the code, if so what is the issue you are having?

The problem we are having is, I can not access the site to test it. I am only working on assumption.

Correct, I wish I could give you access but if you go to that website its some sensitive data. If I could parse out the time stamp that would be great, I just want the code to "look" if the date in Row 8 matches the date in bold, if it matches I want it to put the elevation of the upstream and downstream in their respective cells.

I am looking through your code right now and I think I can edit it to suit my purposes, I will let you know!

Ah!
If the date match, you want to return the up and down elevation number in A6 and A7? Am I right?

yes! Exactly what I'm looking for!

Try the attached. Run and test it. You might got an error as I have not tested it on real data, but it works on my sample test. If the split does not work, I need to find another way of extracting the dates and numbers.

getting a "Run-time Error '13': Type Mismatch

On Upstream in UpDowdstream

I can not see this word "UpDowdstream" on my code.
I have cheated the site and pretended I have got the upstream and downstream values and the code seems to work.
Could you please run it step by step using F8 and see in which line errors. I have also included msgbox to see if the site is returning the correct data.

so there is a period I missed at the end of the "Current tailwater (EL): 252.27 (m) at 11/23/2016 21:15." and that seems to be throwing off the code. Once I add the . to the test code it produces the mismatch error.

Does the code return

"Current pool (EL): 301.42 (m) at 11/23/2016 21:20"
"Current tailwater (EL): 252.27 (m) at 11/23/2016 21:15
?
I asked you to run the code using F8 and to see if these values appear on message box, but it does not appear you are following my guide. Please let's take step by step.

The code returns "Current pool (EL): 301.41 (m) at 11/24/2016 01:10." and "Current tailwater (EL): 252.28 (m) at 11/24/2016 01:15." Note the added period at the end now. Would that cause it to throw a mismatch?

Appreciate the help, you have no idea how big the impact of this working will be.

Yes, if there is a dot, it is not longer a date, but a string. This is quick fix, while I work on replacing it with different approach.
Try it and see if this quick fix it.

Thank you AB33! Works like a charm!