I have 20 work sheets in one Excel book. the last sheet contains all the data
from the rest of 19 sheets. I want to validate if the data in the last sheet
is exactly the same as in the rest of 19 work sheets. What kind of function
should I use? or how should I do it. I feel there must be a quick way to do
it. Each sheet looks like below, including the last sheet.
item # 24-Jul 31-Jul 7-Aug 14-Aug
1 0 25 0 40
2 5 8 10 0
3 0 0 0 0
4 0 0 1 0
Thank you.
Bookmarks