how do i create combo list box that is A. searchable B. auto complete C. removes selections.
sheet team brooks
[TABLE="width: 398"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 5"]Brooks[/TD]
[/TR]
[TR]
[TD]Pick[/TD]
[TD]Roster[/TD]
[TD]Player[/TD]
[TD]Team[/TD]
[TD]Bye Week[/TD]
[/TR]
[TR]
[TD]Pick #20[/TD]
[TD]QB[/TD]
[TD]Chad Henne[/TD]
[TD]Baltimore Ravens[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]QB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Pick #1[/TD]
[TD]WRorTE[/TD]
[TD]A.J. Green[/TD]
[TD]Cincinnati Bengals[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WRorTE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WRorTE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WR/TE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]K[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]DEF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
i have a group of players by position which is index listed off of position selected on brooks sheet list.
not too familiar with macros.
sheet team brooks
[TABLE="width: 398"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 5"]Brooks[/TD]
[/TR]
[TR]
[TD]Pick[/TD]
[TD]Roster[/TD]
[TD]Player[/TD]
[TD]Team[/TD]
[TD]Bye Week[/TD]
[/TR]
[TR]
[TD]Pick #20[/TD]
[TD]QB[/TD]
[TD]Chad Henne[/TD]
[TD]Baltimore Ravens[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]QB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]RB[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Pick #1[/TD]
[TD]WRorTE[/TD]
[TD]A.J. Green[/TD]
[TD]Cincinnati Bengals[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WRorTE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WRorTE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]WR/TE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]K[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]DEF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]BENCH[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
i have a group of players by position which is index listed off of position selected on brooks sheet list.
not too familiar with macros.