Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide multiple work sheets at once | Excel Worksheet Functions | |||
comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) | |||
Excel Work Sheets | Excel Discussion (Misc queries) | |||
How to copy the work sheets from different workbooks into one? | Excel Discussion (Misc queries) | |||
Multiple Work Sheets | Excel Worksheet Functions |