Code to write to a cell on another sheet

Originally Posted by Norie

Neil

What if it rains?

Well, I will deal with that using the cell that I write 'Y' in for 'Game Over'

Richard

Can you upload the workbook with some typical results and indicate which are the results cells and some notes as to how you've arrived at them with reference to the contributory cells.

Since you can't use a cell for both a formula and manually overwriting it with a constant you will need to use a Sheet Change event macro.

I'll do that later so you can see where I am at