hey all,
let's say i have a list of employee id's on sheet1. And on sheet 2 there's a
list of employee records vacation hours taken (1-to-many). what is the best
way to iterate thru sheet1 and sum up all the hours for each employee in
sheet2 and place the total in a new column in sheet1 next to respective
employee?


sheet1
id,name,total hours
1,john doe,16

sheet2
id,hours,date
1,4,5/6/07
1,4,12/1/06
1,8,3/12/06

thanks,
rodchar