| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation List
Instead of leaving blank cells, you could use a dynamic range as the
list source. There are instructions he http://www.contextures.com/xlNames01.html wrote: I am using a range (A1:A10) as a data validation list for Cell B1. The range A1:A10 is flexible in that I can enter up to 10 items in this range, which the user can select in cell B1 using the drop down list. Not all 10 items are entered in the range (A1:A10). Sometimes I need to enter 6 items, sometimes 9. Is there a way to show only the number of items that are filled-in in the list & not the blank ones? TIA Vinay -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a Data validation list to select another validation l | New Users to Excel | |||
| data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
| data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Threaded Mode
