Excel wizards - Need on a macro to perform a searchable drop down list (Like google , Type in T in a cell dropdown shortlist starting with "T" or "club" shortlist club from list IN Colum A and same with groups dropdown(Col C), Have long list in dropdrown items and its difficult to pick by scrolling.
Tab (2. Planning) - column A (R13:R18) has drop down list co related to Column C(Groups) R13:R18
same macro should apply to all dropdowns in spreadsheet.
Note :Tried data validation and CF, but was able to apply to just 1 cell,unable to do same setup to below cells.
Have uploaded sample file
Tab (2. Planning) - column A (R13:R18) has drop down list co related to Column C(Groups) R13:R18
same macro should apply to all dropdowns in spreadsheet.
Note :Tried data validation and CF, but was able to apply to just 1 cell,unable to do same setup to below cells.
Have uploaded sample file