Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
existing data in case of data validation | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |