Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- 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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL Server UPDATE Database from Excel Table | Links and Linking in Excel | |||
Excel Database | Excel Discussion (Misc queries) | |||
Excel as a database | Excel Discussion (Misc queries) | |||
Keeping date format of a field inserted from an excel database | Excel Worksheet Functions | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) |