Re: Set Data Validation list to ignore blanks in source list
Thanks again for the explanation. Is there a way to automate the process? In other words, I would like for the drop down lists to automatically remove the blank values that are returned without having to do an array type of command or any input from the user. The user should just be able to copy & paste in the data base, and all the drop down lists will be updated without blanks.