How to make the data import from Web a Month to date row?

[hkaraca]

I have a small challenge for one of the sheets I am working on that I need the assistance of my fellow excel users.

I am getting an external data from the web and the table (external data) has 10 rows always reporting for the last ten days. I want to roll this across to my sheet as a 'to date' basis from the day one of the data stream starts.


External Data - (that shows always the last ten days) :

Current rate (by day)
02/11/2014 0.12%
02/10/2014 0.13%
02/07/2014 0.13%
02/06/2014 0.13%
02/05/2014 0.15%
02/04/2014 0.13%
02/03/2014 0.14%
01-31-2014 0.23%
01-30-2014 0.16%
01-29-2014 0.16%

And I want my internal table to lookup above and continue adding new days to on an ongoing basis (as the data gets updated).

Any help would be greatly appreciated.

Thank you.

Regards,
Haluk