Update Spreadsheet from Internet page

[kashifjillani]

Hello Experts,

This seems to be tuff one, and need a bit of attention... it will earn brownie points in front of my Boss.

Original Task:
Update meteorological data file from website daily by 9:00 AM

e.g.

Kiewa at Bandiana 1.2m
Kiewa at Mongans 1.0m
Yackandandh 1.3m
.
.
.
and so on (around 30 streams + 2 reservoirs + 10 Raingauges)

problems here:
The updates are not always in same sequence (sometimes few streams are not reported at all in which case I have to leave the field blank)

What I have done so far:
Imported the external data from web (that was easy)

What is needed:
Everyday at 9:00 AM update the all data, and next day proceed to next column

1st Oct 2nd Oct 3rd Oct and so on

any clue guys.

have a look at one of the webpages (mind that some streams are not reported sometimes, but in my spreadsheet I have to leave the row blank)

If someone can get to the solution and need the spreadsheet itself I would be happy to here from them kashif.shah.ks@gmail.com

http://www.bom.gov.au/cgi-bin/wrap_fwo.pl?IDV60151.html



To the geniuses