I named a column "resname" without values as of now but later on be filled with names everytime i update the list with new names.
Now i created a data validation > list > and used the source of list as "=resname". but after which i dont see the existing names in the updated list it only shows blank pick list.. Is it because of the blanks? Please help. thanks
Bookmarks