Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
Validation list behaving strangely in 2003 | Excel Worksheet Functions | |||
Data Validation list selection question | Excel Worksheet Functions | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |