Thread: Automatic Value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 27
Default Automatic Value

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