I have a worksheet where the user identifies a risk and then takes steps to
try and prevent the risk from happening. After the completion of each step
he reassess the Likelyhood and Consequence of the risk happening. I want to
have two cells that show me the latest information on the Likelihood and
Consequence of this risk which automatically update to reflect the latest
informaion as the user completes each step.

What is the best way to do this? In excel he marks each step as being
Completed so I can trigger off of that to read the values.

Thanks in advance