software

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.


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

Something like

Sub ExtractData()
For N = 1 To 5
Workbooks.Open Filename:=quot;C:\bookquot; amp; N amp; quot;.xlsquot;, ReadOnly:=True
Cells(1, 1).Copy
ThisWorkbook.Sheets(1).Cells(N, 1) = Cells(1, 1)
Workbooks(quot;C:\bookquot; amp; N amp; quot;.xlsquot;).Close
Next N
End SubI've made some assumptions that your source workbooks are called
book1.xls, book2.xls etc. and that the data you want to extract is in
A1--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=535267