I am using Data Validation List's within a cell. After i select the cell and
click on the drop down button i select one of the listed text's "VTC". I am
wanting excel to automatically assign the number "1" to another blank cell
in the same sheet when i select the "VTC"... Does anyone know how to make
excel do this. I have tried all the help files and demos and none of them
can tell me how to do this. Any Ideas or help would be greatly appreciated.

Thank You,


--
www.cox.net