This formula should copy down automatically and a new column heading will be created (something like Column1). Add a column to the data table by typing the formula into cell D2.If you haven’t already done so, change the name to the customer input cell to Customer.Now we will add an extra column into our data table. Select the data table you previously created.In the Defined Names section click Name Manager.Type in the name Customer into the name box.Ĭreating a data table will automatically give the data a named range (something like Table1), so we’ll change the name to something more meaningful next.Now lets also add a named range for our customer input.Make sure the range is correct and click OK.Select a cell in data range or highlight the whole range of data.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 |