sorting named range data
 

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