| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
blank entries in data validation list
Hello. I have a data validation list based on a range on another worksheet
named "parts". The range is from B2:B2000. I only currently have about 150 parts in trhe list, but I want to leave the range larger so that when I add new parts in, they will appear in the data validation I have in the cells of the other sheet for part selection. How can I keep the data validation list from showing all of the blank cells in the range? Thank you! Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Where Data Validation List Boxes Open in Mac Excel 2004 | Excel Discussion (Misc queries) | |||
| Adding a blank in Data Validation List? | Excel Discussion (Misc queries) | |||
| update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
| Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
| Handling "Blank Entries" through Data Validation | Excel Discussion (Misc queries) | |||
Threaded Mode
