list validation using list validation...
Hello -
I have two series of data: 1)Expense Category; 2) Expense I want a list validation of all expense categories in one cell. And, have another list populated with expenses that are associated with the chosen category. I am willing to bet this is easy in VBA, but I don't know VBA... Any suggestions? I would greatly appreciate it. |
You don't need code to utilize validation lists and/or dependent lists.
Check out Debra Dalgleish's site for instrucions. http://www.contextures.com/tiptech.html Scroll down to "D" and check out all the pages on Data Validation. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Patrick G" wrote in message ... Hello - I have two series of data: 1)Expense Category; 2) Expense I want a list validation of all expense categories in one cell. And, have another list populated with expenses that are associated with the chosen category. I am willing to bet this is easy in VBA, but I don't know VBA... Any suggestions? I would greatly appreciate it. |
All times are GMT +1. The time now is 10:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com