Hi guys,
I have a worksheet in which the cell A1 can have 3 different values (yes, no, maybe) through the validation data option. I would like to link the A1 cell to a cell B1 in another workbook, and I would like to give a different number per every value (let's say that I want to have the value 1 in B1 for the value "yes" in A1, 2 in B1 for the value "no" in A1 and 3 in B1 for the value "maybe" in A1). How can I do that???
thanks a lot
the dude