From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Create a dynamic drop-down list

Create a dynamic drop-down list - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Create a dynamic drop-down list

“

And then add the data that's in cells B9 through E17 to that peach sheet, and then make all needed changes to retrieve the peach data via the dropdown list. If you got that, get the exercise file, work that out, come back, and I'll show you a way to do it. Okay, you're back. Let's start with that dynamic dropdown list. I'm going to go over here. I'll call this Groups. Then we need blue, green, black. Then we make a table, formatted as a table, let's grab this purple. The table does have headers, okay. Get rid of that filter button. Highlight the content here, and then, let's call this GRP. Now, in cell C2, we go to Data, Data Validation. List. Equals GRP. OK. There's our list. Now, the peach group. New worksheet. Peach. Grab the data. Cut. Put it here. And we're going to make this a table. OK. And in order to make this dynamic, we have to name this table. And we're going to call this Peach.…

Contents