Suppose we have a list of the students enrolled into a class and the admissions are going on. CREATING A DYNAMIC DROPDOWN LIST USING THE TABLES IN EXCEL So we can do it in many ways, but here we would discuss TWO FASTEST WAYS of creating a dynamic drop down list. So, technically we need a way to add our new data into the same NAME GROUP of items. We put this list into the DROP DOWN list after giving it a name. The standard procedure of creating a drop down list is as follows.Ģ. UNDERSTANDING THE CONCEPT OF DYNAMIC DROP DOWN LIST In this article, we will learn to create a dynamic drop down list in Excel. The dynamic word is used because the data can be changed just by adding it to the already present data. So, we ‘ll create a solution for that which we call as DYNAMIC DROP DOWN LIST IN EXCEL. How would it be, if we could do something which would save us from repeating the complete procedure. Be it simple drop down list or the dependent drop down list, if we add some new entries, the complete procedure needs to be repeated.
It means that every time we need to change the data and create a new drop down list every time in both the cases discussed. But think of a better scenario, where we have a list which will populate the options on the basis of the CHOICE MADE IN THE FIRST LIST. The simple drop down list lets us choose the options from a given list. The second was the case of dependent drop down list. This was an excerpt from the previous post “ HOW TO INSERT A DROP DOWN LIST IN EXCEL” which is applicable for the current case too. SO, FOR SUCH CASES WE ALWAYS PREFER CREATING A LIST FOR A FIRM FORMAT AND CONTROLLING THE ENTRY OF THE DATA. Now imagine if we have a 1000 rows and there are slight differences in the format of the entry, no matter it was done by different people, we ‘ll never be able to work on that and we might end up in correcting all the data wasting our time and resources. If we keep the field just open for the entry, if there are a number of people filling up that data, there are bright chances of format problems. If we have to work on the manual entries after the data has been filled, it can cause so much trouble for us if the data is not in the perfect format. Many a times we have fields which have limited type of entries and which can’t be given to the user for manual entry. The data validation is a very important aspect of any data filling job.
0 kommentar(er)
