Automatic Value

D

Dave

How do I get an opposite cell to display the value 10 if the adjacent
cell contains a value just entered?

example:

a b
4 10
5 10
8 10
2 10
 
Top