Monthly Summary

[Daniel]

I have a workbook for each day of the month (M-Sa) Each workbook tracks
employee results for the day. There is a master copy that I use to create a
new file each day, file is called mm-dd-yy xxxx.xls.

I need to create a workbook that is a summary for the entire month.

Example:

7-1-08 xxxx.xls

B4 E4 F4 G4 H4

Employee Name Hours Worked Bills Production Overall Production
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---

7-2-08 xxxx.xls

B4 E4 F4 G4 H4

Employee Name Hours Worked Bills Production Overall Production
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---

etc....

7-08 Summary.xls

B4 E4 F4 G4 H4

Employee Name Hours Worked Bills Production Overall Production
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---
--- --- -- --- ---


Any suggestions on how to automate this process?

 

[Duke Carey]

Your process is much better off in a database but, barring that, in Excel
with a sheet structured like a data table.

Use a single worksheet for the entire month, after adding a column for the
work date.

 

[Daniel]

That would seem logical, but I have 7 worksheets in each workbook. It's on a
network so I could see it taking forever to work in it.