| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Merging data in workbook
I have a workbook containing 20 sheets. Each sheet is identical (used up to 80 rows, columns A to W) and is used to record peoples working hours each day of the week in different departments. Could someone please tell me how to consolidate all the data on the 20 sheets into a single sheet so that this will allow me to see how many hours were worked per day by each person. I don't know if these are complications - each sheet uses 80 rows but some of these will be blank rows; the same applies to the columns. In some cases people will have worked in different departments during the week so thier names will apppear more than once. I hope that this all makes sense and thank you for taking the time to read it 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=345771 |
|
#2
|
|||
|
|||
|
Hi,
could you not use a Pivottable in the summary sheet, selecting Multiple Consolidation ranges? Worth a look.... Hth, Oli -- Message posted via http://www.officekb.com |
|
#3
|
|||
|
|||
|
Try this
http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "y_not" wrote in message ... I have a workbook containing 20 sheets. Each sheet is identical (used up to 80 rows, columns A to W) and is used to record peoples working hours each day of the week in different departments. Could someone please tell me how to consolidate all the data on the 20 sheets into a single sheet so that this will allow me to see how many hours were worked per day by each person. I don't know if these are complications - each sheet uses 80 rows but some of these will be blank rows; the same applies to the columns. In some cases people will have worked in different departments during the week so thier names will apppear more than once. I hope that this all makes sense and thank you for taking the time to read it 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=345771 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Excel workbook as data source for word mailmerge | Excel Discussion (Misc queries) | |||
| What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
| Should Merging workbooks pick up new data or only edited data? | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Linear Mode
