data reentry for ferification

I have a large amount of data in a worksheet that was hand-entered. I want
to go back through and re-enter the data to double-check if there are any
mistakes. I know that there is a way to set up some sort of masking
worksheet that will compare a re-entered value to a previously entered value,
and if there is a content discrepancy, it will be highlighted of formatted in
some way.

For example, in Sheet 1, cell J9, I have the number "12269". So, if in the
alternate sheet I re-enter "12254", an error would pop up or something. Is
there a good way to do this? Thanks!

Hello Kristen,

you could make up a third sheet with the following formula across the
whole data range:

=Sheet1!A1-Sheet2!A1

and the number format

### ###;-### ###;

so zero values wouldn't show up. And in a cell outside the data range
you could sum up remaining errors with the formula

=SUMIF(A1:F100;"<>0")

where A1:F100 is your data range. I'm not sure if you will have to
replace the semicolons by commas either in the formulae and/or the
number format to use them in an english Excel version.

Regards,
Ingolf

Kristen schrieb:

> I have a large amount of data in a worksheet that was hand-entered. I want
> to go back through and re-enter the data to double-check if there are any
> mistakes. I know that there is a way to set up some sort of masking
> worksheet that will compare a re-entered value to a previously entered value,
> and if there is a content discrepancy, it will be highlighted of formatted in
> some way.
>
> For example, in Sheet 1, cell J9, I have the number "12269". So, if in the
> alternate sheet I re-enter "12254", an error would pop up or something. Is
> there a good way to do this? Thanks!