n

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
"Max" wrote:

.. like to attach a file to give as an example ..

You can upload your sample* using a free filehost
and post a **link** to it here
*desensitized as appropriate

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload your sample,
then paste the link into your reply here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---