Dear people,<o
></o>
I hope you can me help on excel (2007 )formula. It concerns a holiday planner sheet, with worksheets from January up to December. On each worksheets in column “A” are standing the names of the colleagues. Further on the sheet in column “AK” stands per month consumed days calculated balance. I want to take over the value of this sum ( from “AK” ) to the next worksheet as an initial sum. ( to coloumn"AJ" for instance )<o></o>
The problem is, that the names of the employees do not stand in fixed row in column “A” per worksheet. How can I put these criteria in a formula, that the person in column “A” gets his/her balance from the previous worksheet? <o></o>
I have tried different lookup formulas: Vlookup, Index, Match, but I’m not even sure that I’m on the right track. Do you have a tip which formula should I use hereby?<o></o>
<o> </o>
></o>I hope you can me help on excel (2007 )formula. It concerns a holiday planner sheet, with worksheets from January up to December. On each worksheets in column “A” are standing the names of the colleagues. Further on the sheet in column “AK” stands per month consumed days calculated balance. I want to take over the value of this sum ( from “AK” ) to the next worksheet as an initial sum. ( to coloumn"AJ" for instance )<o
></o>The problem is, that the names of the employees do not stand in fixed row in column “A” per worksheet. How can I put these criteria in a formula, that the person in column “A” gets his/her balance from the previous worksheet? <o
></o>I have tried different lookup formulas: Vlookup, Index, Match, but I’m not even sure that I’m on the right track. Do you have a tip which formula should I use hereby?<o
></o><o
> </o>
