I've customized the Absence and Vacation Schedule Template to require
employees to submit the total hours that they will be out of the office;
by default, this workflow is applied to the Absences Calendar list.
This part works fine.



The part I'm having trouble with is that the managers (approvers) want a
separate list that contains all the employees, how much vacation time
they have at the start of the year, how much approved vacation time they
have taken and how much vacation is remaining.



So far, on the 2nd list, I have created the necessary columns, employee
name, vacation total (beginning of the year), vacation remaining
(vacation total - vacation taken) and vacation taken (sum of approved
hours requested).



How do I get the approved hours requested from the Absence list to the
2nd list, match it with the correct employee name, and take the total
approved hours requested and add it to the previous vacation total?



Is this even possible with MOSS 2007 and SharePoint Designer?