Changing data, corrupts pre-calculated cells

[InvalidTxtString]

The problem here is "Budget salary % vs. Rev"

The problem is, it checks how many hours the place has in its budget.

It works fine week 1 - everythings lines up.

Week 2, person 4 quit. and two new guys were hired.

How can I make the weeks right, when the staff is shifting - If I delete person 4, then Week 1 won't be correct anymore.
And hiring "Person 5" & "Person 6" till week 2, also messes up Week 1

http://www.excelforum.com/attachment...1&d=1461422204

[JohnTopley]

The only way round this problem is "copy and paste values" (to freeze previous formulae results) , however you manage this: perhaps a VBA macro.

Looking at your Weekly tables you have a formula in Week 1 to insert Names but the hours data does not appear to be copied using formulae.

In Week2 (because of the problem of adding/deleting personnel) the entries are hard coded.

As the budget table appears to be mirrored in the weekly table I see little overhead in just copy/pasting values from your budget table to the weekly table (VBA macro?)

[InvalidTxtString]

The teamleader write the hours in "week X", that's why they aren't copied via formulae.

Figured there would be no way around VBA'ing it :-/