Hi, I've entered the following formula into cell A2 ($D$17*(1-D21)). It copies down to the cell I want it to if I do it manually. I want it to copy down the number of times using a macro automatically. The number of times it should copy to is represted in cell I2. How should I go about doing this?
Thanks much appreciated.