filling cells

  • Thread starter Thread starter Neuther
  • Start date Start date
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
 
Hi, may I know whether your combo box list need to be update
dynamically ? or you just need to fill it once
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I count the number of cells that meet multiple criteria? 7
Cell References 2
Is there a better way to write this code... 9
Do ALL labels at ONCE 14
More Conditional Formatting 1
Automate the Find function in Excel 2
Actions on certain Worksheets 5
Another Error 8

Back
Top