Updating grouped cells

[Tripper]

I am trying to select only the lowest level cells in a spreadsheet with
grouped columns.

The spreadsheet has cost centres grouped into departments. The
departments are grouped into divisions. The cost centres get their
values from other sheets and workbooks.

I would like to be able to change the formulas in the cost centre
columns only - without disturbing the sum formulas in the department
and division columns.

Is there a quick way to select only the cost centre cells in a row
without selecting them individually?

 

[Joerg]

Probably not. But if you have to do that frequently, why not select the cost
centres individually (I know, that's what you want to avoid, but you have to
do it only once) and give this selection a name in the 'name box' (the upper
left thing). Next time just select your cost centre(s) from that name box.

Joerg

 

[Tripper]

Thanks Joerg - that's a good idea. The only problem is I usually only
want to select one row to copy a new formula to, not all the rows and
not always the same row.

I might have to sharpen my VBA skills and create a macro to do it.

The moral of the story is: Don't group columns until you are sure the
model is stable.

I have also considered placing only the cost centres in a group of
rows, then only the departments in a different group of rows, and
finally only the divisions in a third group of rows. I could use some
hyperlinks to mimic the expanding and collapsing that grouping
accomplishes. It wouldn't be so elegant, but it would be a lot easier
to maintain.

Tripper