There may be an easy solution to this problem but i cannot seem to get it.

I have this formula in a cell ='Teacher Summary'!C4. i want to drag it down and fill it with ='Teacher Summary'!D4, then ='Teacher Summary'!E4 , etc.

But it keeps going to ='Teacher Summary'!C5, then ='Teacher Summary'!C6 etc.

Any help would be greatly appreciated

George