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

Attached Files

	January.xlsx (35.8 KB, 27 views)
	day 1.xlsx (13.8 KB, 20 views)
	day 2.xlsx (13.9 KB, 16 views)
	day 3.xlsx (13.9 KB, 15 views)
	Montly Total .xlsx (23.7 KB, 22 views)