Copying Formulas In Cells That Are Not Nested

[Guest]

I would like to copy formulas in cells that are not nested (grouped), but not
to cells that are not currently showing.

Basically, I have pieces of a system that show individual costs. These are
gouped under a total category. I want to copy a formula, typically sum or
average, to only the total categories. These are hundreds of these. I have
been copying these formulas manually, but would like to find a shortcut.
When I attempt to drag the equation down and copy to only the cells that are
displayed (total categories), the formula is copied to the cells that are
grouped or nested under the total category.

Thanks for the help!

 

[Bryan Hessey]

If you can use AutoFilter to display these required cells, you can then
Copy the required cell, and drag-select the displayed required cells
and Paste.

Normally Hidden cells and Group cells seem to produce the results you
observed.

Hope this helps

--