Fifi !!!!!!!!!!!!!!!!!!!
Stop talking about macros.
Macros have nothing to do with it.
You just want to copy a formula from one cell to another.
You can do it with the mouse as Max suggests.
Or with the keyboard as I suggest.

You need to get more familiar with the basics before getting on to macros.

You're trying to do the triple-salto before the cartwheel.

Gloria.