Check data entry in Excel
Regarding checking data entry in Excel in addition to using VBA, there is another simpler way that is using Data Validation tool of Excel.
For example, when checking product codes, suppose you have a product code contained in the range A1: A20 of Sheet1 , the item code entry part in range A1: A10 in Sheet2 .
To make it easier to manage this range, name it by selecting Insert à Name à Define , naming the Sheet1! A1: A20 area as Mahang , clicking OK .
To enter the test conditions for this region, do the following:
Go to Sheet2 à Select area A1: A10 and Select Data and Data Validation .
On the Settings tab , Validation Criteria select Allow : List , Source enter = Mahang , check the Ignore Blank box if you want to ignore the empty boxes, In-cell dropdown box if you want a drop-down list box.
Switch to the Input Messsage tab, enter the instructions, select Show input . if you want the instructions to appear when the cell is selected.
Switching to the Error Alert tab enter the warning information when it is entered incorrectly, select Show error . if you want to show the warning information.
Click OK .
Now when entering data in Sheet2! A1: A10 area , a Dropdown List box appears and almost certainly you don't have a chance to enter the wrong code!
In addition, you can refer to other advanced data entry techniques at the following websites:
- English: www.contextures.com/tiptech.html, download the example file www.contextures.com/DataValSample.zip
- Vietnamese: www.webketoan.com, www.giaiphapexcel.com (http://www.giaiphapexcel.com/forum/showthread.php?t=98&highlight=Data+Validation).
Nguyen Trong Thanh
Email : ng.tr.thanh@gmail.com; ntthanhhp@vnn.vn
You should read it
- Method to enter data simultaneously into multiple sheets
- Tricks to import data in Excel fastest
- How to enter a text into multiple Excel cells at the same time
- How to Enter Data in SPSS
- MS Access 2003 - Lesson 7: Enter information for the table
- How to Use Minitab
- How to automatically enter passwords in Android
- How to fix the problem of being unable to enter Terminal in Linux
May be interested
- How to remove periods in numbers in Excelhow to remove periods in numbers in excel when typing a string of numbers, data entry people have a habit of inserting dots in the middle to easily observe the data and reduce errors when entering data. however, in some cases, the dot will make the calculation impossible.
- How to make Excel spreadsheets smarter with drop-down listsdrop-down lists are your secret weapon against data inconsistencies and typographical errors, making data entry easier and more accurate.
- How to check the version of Excel in usethe operation of checking the version of excel in use on the computer helps users choose to upgrade or use the current version.
- 3 ways down the line in Excel, line break, down row in 1 Excel cellthere will be 3 ways downstream in excel, suitable for each case of content entry. please follow the downstream instructions in excel below for details.
- Warning of duplicate values in Excel - Warning of data duplicationmicrosoft excel gives you lots of useful features to help your data entry work best. one of those features is the duplicate value warning feature.
- Guidelines for importing Chemistry formulas in Excelentering chemistry formulas in excel spreadsheets helps us to handle formulas more easily, especially for those who often have to work with chemistry or with math when they have the above index, the index below.
- How to check data entered in a cell in Excelthe following article details how to check data entered into a cell in excel.
- Summary of 50 Excel shortcuts you should know by 2023microsoft excel is widely used globally for data storage and analysis. although there are many new data analysis tools on the market, excel is still the go-to product for working with data. it has many built-in features, making it easier for you to organize your data.
- 10 EXCEL functions that ACCOUNTERS often usein excel, there are many functions that can help accounting in daily data entry, but here are some common functions used by accounting.
- Complete guide to Excel 2016 (Part 11): Check spelling in the worksheetlet's tipsmake.com refer to the spell check tutorial on excel 2016 worksheet in this article!