Thaks Max for your work on this - I will need to take some time to follow
through the formulae as my excel knowledge is basic, to see what you have
done.

One thing though- I would need the 2 rosters kept seperate and not on the
same sheet as in Roster hours (2). Can that still work with your file?

Mike

"Max" wrote:

One possible approach, implemented in this sample:
http://www.freefilehosting.net/download/3gj8j
Roster_Automation_1.xls

In Roster hours (2),
With Team A's names listed in A10:A13, Team B's in A14:A17

For Team A
In B10:
=IF(ISNA(MATCH($A10,OFFSET('Team A Roster'!$B$4:$B$7,,MATCH(B$3,'Team A
Roster'!$C$3:$G$3,0)),0)),"",INDEX('Line Hours
accumulation'!$B$4:$B$7,MATCH($A10,OFFSET('Team A
Roster'!$B$4:$B$7,,MATCH(B$3,'Team A Roster'!$C$3:$G$3,0)),0)))
Copy B10 across/fill down to F13 to populate

Similarly for Team B
In B14:
=IF(ISNA(MATCH($A14,OFFSET('Team B Roster'!$B$5:$B$8,,MATCH(B$3,'Team B
Roster'!$C$4:$G$4,0)),0)),"",INDEX('Line Hours
accumulation'!$B$4:$B$7,MATCH($A14,OFFSET('Team B
Roster'!$B$5:$B$8,,MATCH(B$3,'Team B Roster'!$C$4:$G$4,0)),0)))
Copy B14 across/fill down to F17 to populate
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MikeR-Oz" wrote:
Max - Thaks . The link is

http://www.freefilehosting.net/download/3gj79

To try and explain what I am after:

There is 2 rosters for 2 teams working 8 weeks.

Each Line or row attracts a set number of hours , so if a staff member is on
that particular line (row) for that week then he will have been assumed to
have worked the hours that the line(row) attracts.

I would like to automate the process so that a sheet containing the roster
indicates against the staff name the hours worked each week and the total
hours worked for the entire roster at the end. This to be for both Team A and
Team B roster.

The list of Staff names can be on a seperate sheet.

How can I get the 'Roster Hours' Sheet to auto poulate 'knowing' the hours
of each line by the staff members name??

Cheers
MIke