If you have the data in cell F12 and below, then only have to double-click on
the little black square in the lower right hand corner of G11 after you enter
the formula there, and the formulas will fill down as far as there is data
in column F.

Vaya con Dios,
Chuck, CABGx3



"Neo1" wrote:

>
> Hello I have a simple problem I want to create a macro so that instead
> of dragging the formulae down to create a copy....
>
> =E11/F11 I want to put this formula in G11, now the problem is i
> want to make this formula apply to the other cells below such as:
>
> =E12/F12 in G12 etc etc like this all the way down, instead of
> dragging it can i make a macro if so can anyone explain please
>
> Thanks for your time
> From John Wood
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
> View this thread: http://www.excelforum.com/showthread...hreadid=506971
>
>