ragamuffin
07-28-2007, 12:51 PM
Hi,
I have a scan sheet that I need to validate so that cells E8:AP308 will only allow numeric characters eleven digits in length. That is, spaces, decimal points, and letters should not be allowed into the cells even if they add up to eleven characters. This is to scan serial numbers for inventory purposes, so anything that falls outside of the criteria needs to be flagged. I know that there is an error check feature in excel, but I am not familiar with it. I need the most user friendly way to allow someone to scan several hundred items and to notice their mis-scans either (1) as each one comes along or (2) at the end of the scanning process so that all mis-scans are highlighted or circled in red or something to that effect so that they can go back and correct them accordingly - I am leaning toward option #2, so that the scan can be done in one lump process and then the corrections in one lump process, but I am open to suggestions. I am also leaning towards a data validation if at all possible, but a macro with button may work well too.
My sheet is attached. There are two tabs which are basically the same thing, one for a sellable location and the other for a return location. The validation or macro should work the same on both sheets, but independent of each sheet.
Any help with this would be greatly appreciated!
Thanks for any and all help!
rm
I have a scan sheet that I need to validate so that cells E8:AP308 will only allow numeric characters eleven digits in length. That is, spaces, decimal points, and letters should not be allowed into the cells even if they add up to eleven characters. This is to scan serial numbers for inventory purposes, so anything that falls outside of the criteria needs to be flagged. I know that there is an error check feature in excel, but I am not familiar with it. I need the most user friendly way to allow someone to scan several hundred items and to notice their mis-scans either (1) as each one comes along or (2) at the end of the scanning process so that all mis-scans are highlighted or circled in red or something to that effect so that they can go back and correct them accordingly - I am leaning toward option #2, so that the scan can be done in one lump process and then the corrections in one lump process, but I am open to suggestions. I am also leaning towards a data validation if at all possible, but a macro with button may work well too.
My sheet is attached. There are two tabs which are basically the same thing, one for a sellable location and the other for a return location. The validation or macro should work the same on both sheets, but independent of each sheet.
Any help with this would be greatly appreciated!
Thanks for any and all help!
rm