Qurey Excel database?
 

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 :confused:


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=394907

Have you considered using Data/Consolidation? With this you can
consolidate data from multiple spreadsheets into a single spreadsheet.


--
humejap
------------------------------------------------------------------------
humejap's Profile: http://www.excelforum.com/member.php...fo&userid=5506
View this thread: http://www.excelforum.com/showthread...hreadid=394907