Thread: How to auto-adjust multi-workbook formulas when adding/removing rows ?

Whenever inserting/deleting rows in a worksheet, the formulas referencing cells in that worksheet automatically adjust - as they should.

I have created a timesheet system that consists one one workbook per employee and one department total workbook. In all workbooks, each row represents a distinct project.

When a project row is added / removed in the individual employee worksheet, I keep the dept totals rows in sync.

in the dept totals workbook, each row is a project and each column an employee.
Each total cell is thus referencing a specific cell in the employee's running total for the corresponding project row, like this:

row 11, column C: Project A for employee_xyz, formula: =[employee_xyz.xlsm]Fiscal!C11

The problem is that if I add a new project (a new row) in all the employee's workbooks and do the same in the dept total, the dept total formulas don't adjust automatically, e.g. in
the example, although project A is now on row 12, the formula still references C11.

Any idea on how to have the formulas automatically adapt ?

Thanks !

poliver -

Did you come up with a solution for this? I am struggling with the same...