I have a web query that refreshes every minute obtaining a table from
a website.

What I would like to do is to log changes that are made to any part of
the table on to a separate sheet (or area on the sheet) - just the
entire rows that had cells that did change.

As an example with the first update that is done the table that is
returned would look like this:

A 12
B 14
C 15

Due to this being the first table recorded the entire table would be
logged. Let us assume that upon the second update (a minute later) the
table that is received is as follows:

A 12
B 14
C 15

Now because there is NO change to the last table nothing new is
logged. However, if in the next minute the table that is received
looks like this...

A 11v
B 14
C 15

Then I would like the log to include the first table that was
recorded, but now the entire row that has the change the row
containing the data "A 11v". Therefore, the log would like this...

A 12
B 14
C 15
A 11v

Thanks in advance for anyone's ideas, or help.


Ryan