As per a post by Dallas viewtopic.php?f=61&t=13533
This query scrapes the data and puts it into a Table in Excel.
To update, simply select a cell in the Table and go to Data Tab > Refresh
The query will update only with 'Todays' date and insert that date accordingly. To keep a record of each days records I added a 2nd sheet that allows you to copy 'n paste from TodaysDate tab to the HistoryData tab.
To quickly do this select any cell inside the TodaysDate table and press CRTL A, then CRTL C. Go to the HistoryData tab and select the last cell in the range (in the Date column), then move down one more cell (so it seems you are outside the table) and then press CRTL V.
You will know if it has copied properly as every other row is shaded. If it doesn't, it means you have not copied it properly.
Design and style is completely up to you
![Smile :)](./images/smilies/icon_e_smile.gif)