data validation drop down list format

P

Pwinkle

Hi, I created a data validation range that users enter information into to
create the drop down list. The user does not need to enter information into
all cells in the range. I use the result of the information to generate
effort, duration, and resource usage for copying to MsProject so the blank
fields in the range must not generate results. The problem is that the drop
down list doesn't read from the top unless all cells contain information.
Does anyone have ideas on how to format the list to show from the top
regardless of the empty cells?
 

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

Top