Updating grouped cells

Giganews Newsgroups
Subject: Updating grouped cells
Posted by:  Tripper (tripper6…@hotmail.com)
Date: 8 Jan 2007

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?

Replies