View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
glenn glenn is offline
external usenet poster
 
Posts: 122
Default 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