Add a drop down list in excel9/20/2023 ![]() This will allow things to update automatically when we add data to our table. ![]() We also want this all to update effortlessly as we add new rows to our order data or if we enter a different customer ID into our first cell.įirst, we’re going to turn our data into a data table so we can reference it with named ranges. What we want to be able to do is enter a customer ID in a cell then in another cell have a drop down list of the items this customer has ordered (and only their items). ![]() This means the content of the drop down list will depend on another selection and some set of data. In our example we have a set of product order data that contains a customer ID, and order ID and the ordered item description. In this post we will explore how to create a drop down list with dynamic content.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |