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
Kirsten,
Check out 'Data' - 'Validation' on the menus. Try data validation in help for descriptions of what can be done. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "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 |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com