Hi All, I have a loan repayment schedule on an excel template such that the cell E11 contains a variable number P (i.e E11=P, which is determined by a formular, thus subject to variation), the cell B7=k (where k is a whole number with the condition that k>0 or k= 0). If k=0, I want the cells E13 to E150 on the column E to be automatically filled with the value in cell E11 (E11=P) If k=1, I want the cells E14 to E151 on the column E to be automatically filled with the value in cell E11 (E11=P) If k=2, I want the cells E15 to E152 on the column E to be automatically filled with the value in cell E11 (E11=P)..................................................................................................................................................................................................................................................................................................................... In general, if k=n, I want the cells E{13+n} to E{150+n} to be automatically filled with the value in cell E11 (E11=P) Please I don't want a drag filling of the cells using the mouse, I want the required cells to be automatically filled with the value P in the cell E11 immediately the number k is altered. Help me please. I know this is possible because we have a bunch of talent in the house. Please help. Kolly.
Last edited: