Production Tracking

[TIM HAGEDORN]

I currently track my daily production on an excel
worksheet. I keep an entire week on one sheet (I have
multiple sheets in the workbook-inventory/sales etc.- all
of which are tracked daily and accumulated weekly). So
each of my workbooks have 1 weeks production, sales, and
inventory in 1 workbook. I then have 52 workbooks at the
end of the year. I would like to be able to combine these
into Quarterly reports.

I understand that this is a very extravagant, but does any
one have any suggestions???

Thank you

 

[Debra Dalgleish]

How many rows of data do you collect each week? If you have thousands of
rows, it would be better to collect the data in a database, such as
Microsoft Access. For smaller amounts of data, store it in Excel, but in
as few workbooks as possible. For example, have one workbook per year,
or per quarter, rather than one per week.