How do I save external data in Excel?
 

I use 'Get External Data' 'From Web' to pull an HTML table of single row from
a website into my Excel file. In 'External Data Range Properties' in 'Refresh
Control' I have set it to 'Refresh every "1" minutes'.

I wish to save new data from the sever in every refresh in my Excel file,
one row above the previous so that the latest data arrives in the top row and
the previous data is pushed down.

What is the best way for doing this? Is there a way I can trigger a macro on
every refresh?

Thanks in advance!