Ya i know its real simple to do that way but its for a report so they
want to be able to click a button n hey presto...it does the job for
them
i get the other ways and thanks for that

Gloria Thrurk wrote:

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.