I have a workbook that pulls data from a website and changes daily. I would like to know what has changed from day to day (or even week to week). Is there any way to do this?
I'm using the IMPORTHTML function, so the sheet doesn't necessarily change, but the data does. I would like a snapshot of the data every so often, compare it to the previous day's data and then publish the differences in a separate sheet.
I searched through this forum, but couldn't find anything relevant to my needs.