Hi, I am new to this forum,
Help Please.
for example:Using Excel 2010
I Imported some LIVE web data onto Column A Row 1, then set refresh at every 1 min.

How can I store the next refresh data onto Column A Row 2 without "overwritten" the last data on A1?

Those web data needed to be updated every 1 minutes, for over 2 hours. All data captured needs to be stored for future analysis.

Hope a simple Marco or VBA can do the trick.
Thanks for your help in advance,
Trinity.