| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Unique List & Alphabetized
Hi,
I'm using a column on a worksheet as the source for data validation for another worksheet. The column used often contains double entries and the worksheet it is in is always sorted using criteria in a separate column. The result is that my Data Validation list is not sorted and contains duplicates. Is there a method for extracting the list for Data Validation and having it sorted A-Z using VBA? I should mention that the list is constantly being modified. Excel 97 on XP -- Casey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - List of unique values | Excel Discussion (Misc queries) | |||
| Need UNIQUE values for Data Validation List | Excel Programming | |||
| Unique numbers from data validation list | Excel Worksheet Functions | |||
| Searching an Alphabetized list for data, then RESORT | Excel Worksheet Functions | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Threaded Mode
