I have a yearly roster with 4 staff 1st sheet="roster". Am trying to sum
hours for each week for staff on their own sheet, eg 2nd sheet="kerry". Am
assigning each week with name eg week1 to week52 range so next year only have
to change name range and leave individual staff sheet alone.Eg below says
kerry=13 hours leave in week 1, sue=14hours week1, john=10hrs, brad=10hrs.
Need to label range at least b2 (m) to h6. each staff sheet then calls their
own row from the named range (week1) and sums the hours for their row.???
A B C D E F G H
1 1 2 3 4 5 6 7
2 m t w t f s s
3 kerry 8 3 2
4 sue 1 6 7
5 john 1 9
6 brad 3 7
--
ShaneBrowning, many thanks