Scroll function help

[masond3]

Hey guys

Sorry to bother you with this post, but i am a little stumped.

On the Gannt Chart Tab, column O – Column CN

Basically the tick function within the Gantt chart tab in column C is influenced if you scroll the associated Gannt chart “Column O – Column CN” down as it locks the value of that cell. So for example you scroll down the Gannt chart you will see all the completed mark in column C disappear. Also the completed value is influenced by this on the dashboard too.

Anyway that i can stop this from happening ?

[Ace_XL]

Why dont you change formula in C10 to

=IF(M10=1,1,"")

[masond3]

Ace_Xl

I hope it is not as simple as that !
If so what a school boy error, i spent 3days trying to work out what was wrong ha