If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Selective Workbook Data Summing
I've created a Monthly Plant Activity workbook, with 31 Daily Reports.
Each Daily Report has a list of Serialised Equipment used and the hours they worked. For any given day, the equipment used may have a different serial number, or the same number as used previously (either the day before or from some other time in the month) I want to create a monthly summary sheet that will automatically scan across the 31 sheets and populate the summary sheet with a list of unique serial numbers Next, I would like the summary sheet to cull the hours used for each item listed from step one above and present a total hours used for the month beside each unique item. I have gone around and around on this, but my limited Excel skills just aren't up to the challenge. Any help (especially yours, Harlan - GOD of all things Excel) gratefully accepted. Don Kirk --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Selective Workbook Data Summing
Hi Don,
Without code or formulas and a few? minutes.... 1. copy the data from each sheet to the summary sheet. 2. paste the data for each sheet below the previous sheet so the columns line up. 3. sort the combined sheet by the serial number column 4. use Data | Subtotals to sum by serial number & hours. The same thing can be accomplished with VBA code, but you would have to pay me.g Others may jump right in here. Regards, Jim Cone San Francisco, CA "donkirk " wrote in message ... I've created a Monthly Plant Activity workbook, with 31 Daily Reports. Each Daily Report has a list of Serialised Equipment used and the hours they worked. For any given day, the equipment used may have a different serial number, or the same number as used previously (either the day before or from some other time in the month) I want to create a monthly summary sheet that will automatically scan across the 31 sheets and populate the summary sheet with a list of unique serial numbers Next, I would like the summary sheet to cull the hours used for each item listed from step one above and present a total hours used for the month beside each unique item. I have gone around and around on this, but my limited Excel skills just aren't up to the challenge. Any help (especially yours, Harlan - GOD of all things Excel) gratefully accepted. Don Kirk |
Thread Tools | |
Display Modes | |
|
|