Hello,
I am again trying to work on a workbook with list on one sheet but multiple sheet can read from that master list via data Validation.
I am looking for help when my list is very long and instead of picking from drop down I will like to narrow it with typing letters in the Cell and then it will populate rest automatic or if multiple name then will give you option to select. I don't like to use VB script. is it possible to achieve this without VB.
Thanks for all the comments or help in advance.
I am again trying to work on a workbook with list on one sheet but multiple sheet can read from that master list via data Validation.
I am looking for help when my list is very long and instead of picking from drop down I will like to narrow it with typing letters in the Cell and then it will populate rest automatic or if multiple name then will give you option to select. I don't like to use VB script. is it possible to achieve this without VB.
Thanks for all the comments or help in advance.