Can someone help please. I want to repeat the formula from the cell above to the cells below in a row a number of times. The number of times the formula has to be repeated will come from another cell - say in my case its cell G24 with the number 10 in that cell. I therefore need to do this repeat formula 10-1 times. Thanks Alsers