Creating a list from a cell's changing values

[benq]

Hi All,

Just have a bit of excel trouble and am wondering if what i am trying to achieve is possible. I have workbook set up where data is updated from a website every minute. So for eg in Cell 3B there is a value of 342, after a minute this value will change to a new one(342 for eg.) downloaded from the url.

What i am trying to do is create a list of these changes that adds each new value to a table so i can track what values have been entered. So in cell A1 would be 342 A2- 324, A3- 423 and continuing as each new value is downloaded. Is this possible with excel? If so can anybody give me a headstart on how to go about this? Thanks

[foxguy]

Hi benq;

I believe it's possible.
Assuming the web query is on Sheet1. The changes to 3B will be recorded on Sheet2

Put this in Sheet1's module (Right Mouse Click on Sheet1's tab and select "View Code").
I'm not 100% sure that a web query will trigger this, but I think so.
This will add a new row in Sheet2.Column A every time something changes on Sheet1, either manually or by a macro.

Please Login or Register  to view this content.

If you only want to add a value to Sheet2!Column A, if B3 has changed then put this instead:

Please Login or Register  to view this content.

[benq]

Foxguy,
That suggestion worked perfectly. Thanks so much for your help.