Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation list
i'm using a data validation list. when i select an item from the list i want
certain values to populate fields on several worksheets in the workbook. what is the simplest way to do this? i.e. associate a macro for each item in the list? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation list
i figured out problem below, i can use IF stmts but another issue has arisen.
i have the same validation list on each worksheet. when i select an item from the list on one worksheet i want to corresponding item to be selected on the lists in the other worksheets. how can i do this? thx for any advice. "mike" wrote: i'm using a data validation list. when i select an item from the list i want certain values to populate fields on several worksheets in the workbook. what is the simplest way to do this? i.e. associate a macro for each item in the list? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
Crazy Data Validation ... List Validation Not Working | Excel Programming | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Programming |