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

Closed
Hashu - Aug 23, 2016 at 04:03 AM
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