You need to fix the list, say by using sort or advanced filter and filter in
place

--
HTH

Bob Phillips

"Emece" wrote in message
...
Using Data - Validation - List.

In Sheet 1 I specify the name of the List that is in Sheet 2. But this
list
have blank cells and I don't want them to be displayed.

Hope I am clear enough.

Thanks.

"JPW" wrote:

How exactly are you trying to "validate" this data? Formulas? Built-in
functions? Please be more specific and we can come up with something for
you.

"Emece" wrote in message
...
Is there a way to omit blanks when validating data from a list?

I am using a list that have blank cells in it, and when using this
list in
other sheet I don't want this blank cells to be displayed.

I guess I should use a macro to do this, but can´t figure it out. Any
help
would be aprreciated.

Thanks in advance

Emece.-