Gingertrees
10-09-2009, 07:49 AM
Related but somewhat different from this post:
http://www.vbaexpress.com/forum/showthread.php?t=28399
Users can add items in the POCItems sheet from A3:A265. This info is then put into a dynamic named range "GOALS" from C300:C562.
In the blue cells on the Plan of Care and Plan of Care pg.2 sheets, users can select from data validation lists of "GOALS". Due to the sheer number, it would really help if "GOALS" were alphabetized.
Anyone know how to sort the values in a dynamic named range, even though each cell formula is something like
{=IF(ISNUMBER(B300),INDIRECT("A"&B300),"")} ?
http://www.vbaexpress.com/forum/showthread.php?t=28399
Users can add items in the POCItems sheet from A3:A265. This info is then put into a dynamic named range "GOALS" from C300:C562.
In the blue cells on the Plan of Care and Plan of Care pg.2 sheets, users can select from data validation lists of "GOALS". Due to the sheer number, it would really help if "GOALS" were alphabetized.
Anyone know how to sort the values in a dynamic named range, even though each cell formula is something like
{=IF(ISNUMBER(B300),INDIRECT("A"&B300),"")} ?