Hi,

This is the scenario: -
10 departments each with its own worksheet (contains one week of information)
60 rows for employee names per department and the hours worked each day (in each worksheet)

A person could work in 6 different departments during the week
Some departments may not operate at all during the week
I need to assemble the hours worked per day per person onto a summary sheet.

I am sure that its a simple problem - just that I am simpler than the problem!

PLease can anyone point me in the right direction because I can't even think of a way to search for the answer in the help files??

Many thanks

Tony