So I have 1 row with 8 columns (Date/1st/2nd/3rd/4th/5th/6th/7th) on sheet one that is setup with a web query.
Sheet2 is a collection of the data within the 8 columns on the row.
When Sheet1 refreshes data if there is ANY change in the data on sheet1 then it will add another row to sheet2 at the top with the values that are listed (even if some are the same)
It is a collection of data as it is returned from the web query.
Sheet1
08/10/13 12 12 24 54 54 54 54 67
Sheet2
08/10/13 12 12 24 54 54 54 54 67
THEN Sheet1 updates after web query and shows:
08/14/13 12 12 24 35 54 46 46 67
Sheet2 would then show:
08/14/13 12 12 24 35 54 46 46 67
08/10/13 12 12 24 54 54 54 54 67
Sheet2 will collect the data in a new row each time the DATE value changes
Bookmarks