data validation
 

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.

data validation
 

You could use consolidation, you could use a macro to make your summary,
you could use hash controls...


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=564967