You can arrange your data as in sample atached; there are 2 ways:
1. in a workbook with 31 worksheets and a total worksheet,
or, if you insist on keeping a separate workbook for each day, you can use the second way:
Create a blanks folder for your templates (will contain 31 workbooks and a total workbook, linked to all 31 workbooks)
2. Copy blanks folder, rename it February 2011, insert your data; for totals, just open any time montly total workbook. This will keep the links updated for the workbooks inside this folder .
An important issue is that if you add a new row for a new product, you have to add it to all worhsheets and total worksheet. A good idea is to create your template with several blank rows, for new products, and when starting a new month, complete the blanks with last month new products, and empty rows for future new products...
|