![]() |
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