View Single Post
  #1   Report Post  
Emece
 
Posts: n/a
Default Macro to omit blank cells needed

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.-