Comapring old data and updated data and highlight the updates
I was trying to do something fancy and got stuck.
I am pulling data from few excel sheets and those sheets get updated from users on daily basis. They may add data or may update the old data or may delete data. So I used to consolidate all the data together into one sheet.
Is there any way by which I can detect the updates which was done by the user today from the data loaded at the time of previous load?
Re: Comapring old data and updated data and highlight the updates
Thanks for your suggestion, I guess using today will pull only the recent data but I want to compare the entire data each time when I load with the entire data with its value which was present on the previous load.