Monthly Summary


D

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?
 
Ad

Advertisements

D

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.
 
Ad

Advertisements

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top