I'm currently importing a data set using MS Query to sheet "Data", I'm then using an index match function on sheet "Tracker" to take user input and output matching data from sheet "Data" to sheet "Tracker", this data set on sheet "Data" refreshes automatically every hour. However I wish to highlight the changes that are made to sheet "Tracker" as a result of the changes to sheet "Data". Any ideas, as the only way I see to do it is setup some script to copy the sheet "Tracker" then execute the refresh of sheet "Data" then compare the updated sheet "Tracker" to the original sheet "Tracker" and highlight the differences, is there a more simple way to do this?
0 Answers
Related