thanks for the reply

I don't think my explanation was very good.

c4 = 6 so fill in row e1 to e6 with the values 1 to 6
c5 = 4 so continue row e7 to e11 with the values 1 to 4
c6 = 5 continue row e12 to e17 with the values 1 to 5

all these numbers in column C are dynamic

c4 = 35
c5 =126
c6 = 1256
c7 , c8 etc ......down Column C

Help appreciated phil