Hi guys:

I'm think to save web dynamic data of different time in to cells.

There is a page that has a number of logined user on it. I know how to use excel web data to get the value from the page and refresh the cell which contains the value every 5 mins.

However after refreshing I want to make this value static and put it into another cell so it won't change I can keep record. Then when the dynamic cell refreshed again, I take the new value put it in a new cell right under the previous static value cell. Then after many refreshes and long period of time, I can accumulate a column of time series data to record the change of the page.

Can this be done by excel formula? I have been thinking on this for a while. Please help me. Thanks guys

All the best.