vrdiver wrote:tjh290633 wrote:I find that most tables in HTML can be downloaded into Notepad, then copied to a spreadsheet and then recreated by Text to Columns. Column separators are usually tabs, as I recall.
TJH
I was hoping to avoid the legwork (there are 24 pages of data before applying filters) but yes, it's possible to grab the data from the screen(s).
Alternatively, I could get off my backside and work out how to do it properly with a bit of VBA...
VRD
I faffed around this morning trying to download the data into Excel in one hit - the interactive statistic pages displays all the ITs on one page.
I tried the usual cut & paste/unicode data/ text to columns but this didn't work...
So, i decided to contact the AIC (*) and ask them if they could introduce the facility (perhaps write out the data in a .CSV file).
(*) waves white flag