Selective Workbook Data Summing

[donkirk]

I've created a Monthly Plant Activity workbook, with 31 Daily Reports.

Each Daily Report has a list of Serialised Equipment used and the hour
they worked. For any given day, the equipment used may have a differen
serial number, or the same number as used previously (either the da
before or from some other time in the month)

I want to create a monthly summary sheet that will automatically sca
across the 31 sheets and populate the summary sheet with a list o
unique serial numbers

Next, I would like the summary sheet to cull the hours used for eac
item listed from step one above and present a total hours used for th
month beside each unique item.

I have gone around and around on this, but my limited Excel skills jus
aren't up to the challenge.

Any help (especially yours, Harlan - GOD of all things Excel
gratefully accepted.

Don Kir

 

[Jim Cone]

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