ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data verification (https://www.excelbanter.com/excel-discussion-misc-queries/99296-data-verification.html)

Kristen

data verification
 
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!



All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com