G
Guest
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
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