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:
<tbody>
</tbody>
<colgroup><col span="4"></colgroup><tbody></tbody>
Sheet2:
<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.
Sheet1:
1 | 2 | 3 | 4 |
a1 | ff | sdf 45 hg | 3 t 67 sdf |
bsg tjn 33 | f 5 hh sd | d2 2 | eg sd2 |
22 33r sdr | f4rh tg l3 | d ff 3287 ff | |
wr 46 t68jd | s47h vf 44 234 | ||
f378g jj 5 | |||
33 t |
<tbody>
</tbody>
<colgroup><col span="4"></colgroup><tbody></tbody>
Sheet2:
Number | Code |
<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.