Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data reentry for ferification
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
data reentry for ferification | Excel Worksheet Functions | |||
How to Stop ReEntry | Excel Programming |