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/

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