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?