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?
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?