Recording a Macro??
This is my first time recording a Marco.
I would like to know if I have a formula that contains 10 cells
=SUM(U20:U29)/COUNTIF(U20:U29,"0") I would like the Macro to repeat the same
formula in the next set of cells =SUM(U53:U62)/COUNTIF(U53:U62,"0")
Is there a way to set up the macro to replicate the formula 24 cells down?
This way I could use the macro reproduce my formula? I have 550 people with
18 cells to complete going through 6 worksheets and I am doing each one by
hand.
--
Thank You In Advance
Glenn
|