Compare two sheet on weekly to see if any data is missing

[Closed]
Report
-
I have two excel work books which we update daily. Since the sheets are used by multiple users, it is difficult to know if we miss any lines . Is there a way to compare the two sheet on weekly to see if any data is missing. If so pls advise