Hello
I have a drop down list of employees. the file is a template and thus i have dummy names in there for a total of 20 names.
now, my data validation list contains all 20 names, but more than likely the branch ppl will use a max of 5 ppl to add to this list. so instead of having all the blank spaces in the drop down list, is it possible for it to show only the active names?
can anyone help, thx you very much!
Bookmarks