Macro to Look up URL and Check for data on Page

Hi,

I don't know if this is even possible. .my employer is making me check the attached spreadsheet (over 150 Lines) to confirm that the prices in it are accurate. I need to do this daily.

This means I need to paste in the URL (supplied in Spreadsheet) and then see if I can find the last price (Column H) and Effective Date: (Column I) on the webpage URL supplied. If they match it means that our prices are accurate (I add a Comment similar to "Price Ok"), if I can't find a match, then I need to investigate further.

This task is really tedious, and take me about 3-4 hours each day.. I want to see if I can find an easier way to do it. So I want to see if the following is possible:

Is it possible to create a Macro that does the following:
1.Copies the URL
2. Pastes Into Browser
3. Then uses "Find" function to see if there is a Match on the webpage for the entries in Column H AND I
4a. If there is a Match, prints "Ok - Price Confirmed on Website" into Column L (end column)
4b. If there is NO Match Prints "Sorry Ed you need to do some more work!" into Column L (end column)

If I could get it to do this, it would make this task bearable.

I was thinking of trying to do this myself, but wanted to get some advice to see if it would likely be too hard..I have little macro experience..am I dreaming? Or perhaps I should pay someone to do it?

Any suggestions/advise would be greatly appreciated.

Thanks

As an example here is the top line:

Column H (Exit Price) is: 0.6875
Column I (Effective Date) is: 13/01/2011 0:00
Column K (URL where prices are found for this fund): https://online.btfunds.com.au/retail...mium_Cash_Fund

Macro would Take 0.6875 and see if it could find that number in th page above.
Then would Take 13/01/2011 and see if it could find that in page above.

If it found both these on the page, it would print "Ok- Pirces Match" in Column L.

Hope that's clear...
Note: most of these prices will be out of date now as the webpage will have updated.

Cheers

Oh don't worry if it's gonna take that long, don't want to take up your time.

A bit quirky?? Do you think they would be an easier way to do it??

Thanks Ed