Hello everyone.

I have a problem that i need solving. I have created 2 work sheets, one with a roster of the times people are working and the other is a weekly report which has information relating to the roster information.

In the roster I have calculated the hours worked and I need to make sure that the right hours worked are un der the right dates in the weekly report. What needs to be done, so I don't have to play about with it every week, is to somehow assign the hours worked to the dates in the roster and then by matching the dates from the weekly report and the roster, the hours worked will slot right in.

I'm thinking some kind of array needs to be created.

I think I have attached the file, so you can have a look.

Thank you in advance to anyone that helps.