Advanced drop-down menu

amir9s

New Member
Joined
Jun 10, 2016
Messages
9
I'm trying to create drop-down list that automatically detects which list it should put in a cell. here's an example to show what I exactly mean:

Sheet1:
1234
a1
ffsdf 45 hg3 t 67 sdf
bsg tjn 33f 5 hh sdd2 2eg sd2
22 33r sdrf4rh tg l3d ff 3287 ff
wr 46 t68jds47h vf 44 234
f378g jj 5
33 t

<tbody>
</tbody>

<colgroup><col span="4"></colgroup><tbody></tbody>










Sheet2:
NumberCode

<tbody>
</tbody>

column 1 of each sheet is the title column.
What I'm trying to do is to have drop-down menu under the Code column on sheet2 that corresponds to the Number column to its left.
So if I type "1"(or "2" or "3" or "4"), it takes all the values under column "1" (or "2" or "3" or "4") of sheet1 and list them in a drop-down menu for me in the cell below "Column" title cell.
Is this even possible? Thank you.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,130,026
Messages
5,639,610
Members
417,101
Latest member
amoverton2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top