| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recording Macro | Excel Discussion (Misc queries) | |||
| recording macro | Excel Discussion (Misc queries) | |||
| Recording a Macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Threaded Mode
