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