Hello
I have a list of 100 items which are linked to a validation cell, to display as a list in a separate tab.
Is there a way that u can begin to type in the cell and the possible options display.
Eg if I start typing "cha", then only those which begin with cha will display. Such as "channel 1, channel 2,channel 3" do I can then select the one I want....rather than scanning down a list of 100 items.
Thank you
I have a list of 100 items which are linked to a validation cell, to display as a list in a separate tab.
Is there a way that u can begin to type in the cell and the possible options display.
Eg if I start typing "cha", then only those which begin with cha will display. Such as "channel 1, channel 2,channel 3" do I can then select the one I want....rather than scanning down a list of 100 items.
Thank you