Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Verification Problem
Is there a way to create some sort of masking sheet over a current data sheet
that, when I re-input data, can tell me if there is a discrepancy between the two values. For example, on Data Sheet 1, I have the value 98765, and when re-entering the data, I mistype 11234, Excel can notify me of that problem? This is for the purposes of verifying numberic data that has been entered into a speadsheet. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Verification Problem
Kirsten,
Check out 'Data' - 'Validation' on the menus. Try data validation in help for descriptions of what can be done. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "Kristen" wrote: Is there a way to create some sort of masking sheet over a current data sheet that, when I re-input data, can tell me if there is a discrepancy between the two values. For example, on Data Sheet 1, I have the value 98765, and when re-entering the data, I mistype 11234, Excel can notify me of that problem? This is for the purposes of verifying numberic data that has been entered into a speadsheet. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Verification Problem
You have an active thread in .misc, too.
Kristen wrote: Is there a way to create some sort of masking sheet over a current data sheet that, when I re-input data, can tell me if there is a discrepancy between the two values. For example, on Data Sheet 1, I have the value 98765, and when re-entering the data, I mistype 11234, Excel can notify me of that problem? This is for the purposes of verifying numberic data that has been entered into a speadsheet. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Verification Problem | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Case Sensitivity problem with data validation | Excel Worksheet Functions | |||
Problem with Import Data path | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) |