Validation list

[Sean]

I have a validation list sourcing values from 3 sheets by
using cell references. Trouble is if there are blank
values in the reference cells, blank spaces appear in the
list. Sort of like below.

ABC XYZ (blank cell) 123 456

ABC
XYZ
(blank in list)
123
456

Any ideas on how to remove the blanks?

 

[Gord Dibben]

Sean

The blanks will appear in the list if they are in the source.

Copy your cells from the three worksheets to one and remove the blanks. Use
this as source for your list.

Type the values into the dialog box separated by commas.

Gord Dibben Excel MVP - XL97 SR2 & XL2002