Totaling data from multiple workbooks.

[Guest]

I have to deal with about 15 different part numbers on a daily basis, and
turn in reports every day. My daily workbook has 15 sheets, one for each part
number. I also do a daily summary which totals up my daily numbers (good
parts, bad parts, repaired parts, parts returned from customer, etc.). Is
there any way that I can make a weekly summary sheet to total the 5 daily
summaries from the different workbooks? I managed to get the formulas right
for the daily summaries, but I'm no rocket scientist, so I need to keep this
as easy as possible. Thanks.

 

[mrice]

I would recommend a macro which opens each workbook in turn and extract
out the information onto the summary sheet.

Something like

Sub ExtractData()
For N = 1 To 5
Workbooks.Open Filename:="C:\book" & N & ".xls", ReadOnly:=True
Cells(1, 1).Copy
ThisWorkbook.Sheets(1).Cells(N, 1) = Cells(1, 1)
Workbooks("C:\book" & N & ".xls").Close
Next N
End Sub


I've made some assumptions that your source workbooks are calle
book1.xls, book2.xls etc. and that the data you want to extract is i
A