| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Lists
Nevermind, I got it to work. Thanks for everyones help.
"cardosol" wrote: How do I copy the validation to another range of cells. when I do a copy paste special, the formula does not work right, it references the cells above. "jlclyde" wrote: On Apr 28, 11:56 am, cardosol wrote: Hi, I have a spreadsheet where I am tracking expenses. I have several catagories of expenses, like Telephone, Utlities, etc. I want to create two lists, one for the type of expense and the other for the vendor of the expense. How can I create the second list to populate based on the first list selection. For example, if I am doing a list for telephone vendors, I select my first list to Say Telephone and the second list to populate Verizon, AT&T, Qwest, Sprint or if I am doing it for utlities for my first list to populate Utlities and the second list to populate Power, Water, Trash? Go to data/validation\ select list. then in the source range just write an IF statment. If(X = telephone , then chose this list, if not then chose another list or write another if statement. If you write where the information is found, someone could help you write it. Jay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Drop-down lists | Excel Worksheet Functions | |||
| conditional lists | Excel Worksheet Functions | |||
| Conditional lists for a Combo Box | Excel Discussion (Misc queries) | |||
| Conditional Drop Down Lists | Excel Discussion (Misc queries) | |||
| Conditional drop-down lists | Excel Worksheet Functions | |||
Threaded Mode
