Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.programming
|
|||
|
|||
Data Verification Problem
I'm not sure if I understand your need correctly, but it seems to me that you
might be able to do something with a simple formula. If you've got a sheet called 'Data Sheet 1' and you're re-entering on the sheet 'Verify', then try putting something like this in the cell beside your entry. =IF('Data Sheet 1'!B2='Verify'!B2,"","Does not match") Obviously, I'm guessing at which cells you'll actually be comparing. I hope that helps. -- Hmm...they have the Internet on COMPUTERS now! "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.programming
|
|||
|
|||
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 between worksheets | Excel Worksheet Functions | |||
data verification question | Excel Worksheet Functions | |||
Data Verification Problem | Excel Worksheet Functions | |||
Data Verification Problem | Excel Discussion (Misc queries) | |||
data verification | Excel Discussion (Misc queries) |