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!

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!

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