Drop down list with blank cells throughout range.

[moatt]

Hi, I've used this site for help many times, but this was the first time I couldn't find the answer to my question through searching. I've looked all over this site & elsewhere, tried 2 dozen different solutions, and nothing seems to work.

I've used a budgeting spreadsheet for years, which lets me plan bills weekly according to paychecks. For each month, going down the "Expenses" column, there lists are seperated by when they'll occur. So there may be three blank cells, then electric bill, mortgage, blank, blank, cable bill, blank, cell phone, blank, gasoline...

On the checkbook worksheet, I want to enter a drop down box for the Expenses. The problem is, every solution I've found for doing this is aimed at eliminating blank spaces at the end of the list. This by necessity has to have blank spaces throughout the list, but I would like them to disappear in the drop down menu.

Ideas?

Thanks a lot guys.

Chris

[davesexcel]

Check out NVBC's example to see if it would work for you

http://www.excelforum.com/excel-gene...down-list.html

Go to insert Name and check out the formula, for the list name

[moatt]

Ah, I didn't think of extracting the range to another area. I'll give that a shot.

Was going to try it tonight, but changing his code to match spreadsheet is going to take some...finesse. lol

Thanks again, I'll let you know how it works!

Chris

[moatt]

That worked like a charm. It took me a little while to convert it to my spreadsheet (dealing with rows instead of columns), but I still had problems. I was about to give up and post back when it hit me:

CTRL+SHIFT+ENTER!

After that, flawless. Exactly what I needed.

Thanks again. Now on to the next hurdle.

[alijahed]

That worked like a charm. It took me a little while to convert it to my spreadsheet (dealing with rows instead of columns), but I still had problems. I was about to give up and post back when it hit me:

CTRL+SHIFT+ENTER!

After that, flawless. Exactly what I needed.

Thanks again. Now on to the next hurdle.

Hi there,

Can you please explain to me how did you fix the gaps in drop down menu with "CTRL+SHIFT+ENTER"?

Cheers

Ali

[arlu1201]

Alijahed,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.