|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
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?