I work at a regional computer lab. We have always used a simple excel worksheet to track all devices that come into our lab each month and a separate worksheet for all devices that were completed that month. Due to backlog, the devices aren't always completed during the same month that they are dropped off. My hope is to create a more robust workbook. I have created a yearly workbook with worksheets for each month and quarterly statistics pages that will now automate the stats we currently calculate by hand.

If possible, I am hoping to be able to generate our monthly completed jobs form automatically. My thought was for a formula that would copy the contents of a row to a new worksheet when the column for "Date Completed" is populated. I'm at a loss for ideas though since as I said the jobs aren't always finished during the same month. For example device one may be collected in Sept and finished in Sept but device two may be collected in Sept but completed in Oct. That would mean that device one would belong on the Sept summary but device two would belong on the Oct summary. Then there is the problem of a device from Dec of one year being completed in the following year, which currently would be a completely different workbook.

Please help!