filling cells

N

Neuther

i have a colum of cells that depending on a vlookup are either empty o
have text. I want to put these cells in a combo box but i don't wan
to have all the empty cells. the only way i could figue was to us
this formula

=IF(Y7="",Y8,IF(Y8="",Y9,IF(Y9="",Y10)))

only problem is i have over 600 cells i want to do this with. so i
there any way to do this that i'm not thinking of without the typin
cramps??

hope someone can hel
 
M

makisa

Hi, may I know whether your combo box list need to be update
dynamically ? or you just need to fill it once
 
Top