ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   validate work sheets (https://www.excelbanter.com/excel-worksheet-functions/101319-validate-work-sheets.html)

yalanola

validate work sheets
 
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.


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com