Hi

Do you have the cell reference 'locked' , i.e. $C$2, if so remove the $ and the reference will update when copied.

Regards

Jeff