Help!!
I quickly need to understand how to do this.
I have created a data validation option for a cell and using it in a number of cells. There are four options, lets call them A B C and D. When a user selects say A in cell C1 I want Excel to automitcally enter a value for A say 10 to another cell in A1. So user selects A in C1 and automically 10 appears in A1, is this possible?
If so I would like four rules created for this so when an option is selected these numbers are automatically entered into the other cell.
A - 10
B - 6
C - 2
D - 0
Thanks in advance for any answers it will be hugely appreciated.
Many thanks