Y
y_not
Hi,
This is the scenario: -
10 departments each with its own worksheet (contains one week o
information)
60 rows for employee names per department and the hours worked each da
(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 summar
sheet.
I am sure that its a simple problem - just that I am simpler than th
problem!
PLease can anyone point me in the right direction because I can't eve
think of a way to search for the answer in the help files??
Many thanks
Tony :confused
This is the scenario: -
10 departments each with its own worksheet (contains one week o
information)
60 rows for employee names per department and the hours worked each da
(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 summar
sheet.
I am sure that its a simple problem - just that I am simpler than th
problem!
PLease can anyone point me in the right direction because I can't eve
think of a way to search for the answer in the help files??
Many thanks
Tony :confused