hi richard,

I hope, i have understood the issue bothering you and it is very simple. Just click the cell C1, take your mouse pointer to the extreme bottom right corner of the cell, it will turn to a "+" sign and then you have to only drag it down to get the formula automatically copied to the dragged cell.

Reply if this was not the issue or just send me the file to forum@ideaunlimited.in