I assume the data appears in the dropdown as it does in the table.

There is no inherent ability to sort the data in the list. It must be
provided to the list in a sorted order.

--
Regards,
Tom Ogilvy


"klysell" wrote:

Hi,

How do I ensure that my named ranges supply data to my data validation
drop-down lists that are in the proper aphanumerical order? These lists are
dynamically changing based on re-populating data which is then used to
refresh pivot tables. My named ranges that feed my data validation drop-down
lists are also contained on the same pivot table data sheet.

Thanks!
Kent.
--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.948-9557