Step 3: Data validation pop up Step 4: As you select the list you have to enter the source (location) of that list in excel sheet.
Correct sequence of operations is given in below screen shots Step 2: Drop down list in excel Step 3: After clicking on “Data Validation” button under “DATA” tab a new pop up will come where you have to select “List” from drop down” to declare that you are creating a drop down list. Then go to “DATA” tab on excel header and click on “Data validation” button. Exactly where you want the drop down list. Step 1: Drop down list in excel Step 2: Place cursor in just below Plant heading. here is the procedure: Step 1: Let us create a excel sheet with Material, Plant and Storage location as header. If data is correct then it will be an error free upload. Drop down list in excel provides the user a facility to enter correct data in master data template. Let us learn the step by step procedure to create a drop down list in excel. Step by Step process to configure Drop down list in excel This will save not only the time but also the efforts of entire team. Automatically user will enter correct values. If you have configured a Drop down list in excel then system will throw an error if user select wrong plant. Drop down list in excel is one of the solution which can compel core team and end user to prepare correct data in load template. This improves the quality of excel sheet.įor example: If Plant in your project is ‘ABCD’ and user made a typo and provided ‘ABCS’. There is a solution you can use to avoid this problem as long as you actually put it into action.
Like this the cycle of data cleaning goes on and on and consultants lost their valuable time. They sent the data load file again to the user and ask them to provide correct data. They spent lot of time to fix the errors. But while uploading the data they come across lots of error. Because they have to upload the data into SAP at the time of cut over. SAP Consultants spent lot of efforts in preparing Master Data templates and transaction data templates in implementation projects and roll out projects. How drop down list in excel can help you?Īlmost every SAP consultant had made this mistake.
0 kommentar(er)
