Looping Macro Help!

[KHughes687]

<TABLE width="100%"><TBODY><TR><TD>
I have a spreadsheet that has multiple rows for the same date (Col A), each with different product data in cols B-M.
I need to be able to read through each row until the date changes (the number of rows changes each day). Whilst the date matches I need to add the contents of cell B on each row to a total. Once the total for Col B has been gathered I need it written into a cell on another sheet.
I need this to happen for each of columns B-M so that I end up with a totals worksheet.
Each row on this sheet is a unique date in Col A, with totals for columns B, C, etc in the rest of the columns of the row. I also need the script to then continue to do this for all the rows in the original sheet, so that the 2nd sheet ends up with a list of unique dates and totals for each day.
Any ideas gratefully received...!



</TD></TR></TBODY></TABLE>

 

[VoG]

A Pivot Table should work. Example (only a few columns shown)

Excel Workbook
	A	B	C	D
1	Date	B	C	D
2	04/05/2010	0	9	2
3	04/05/2010	6	5	8
4	04/05/2010	0	2	0
5	05/05/2010	3	0	9
6	05/05/2010	2	9	1
7	05/05/2010	7	0	9
8	06/05/2010	1	5	6
9	06/05/2010	10	7	6
10	06/05/2010	0	4	9
11	06/05/2010	7	8	9
12	06/05/2010	6	4	2
Raw Data

Excel Workbook
	A	B	C	D
3		Values
4	Row Labels	Sum of B	Sum of C	Sum of D
5	04/05/2010	6	16	10
6	05/05/2010	12	9	19
7	06/05/2010	24	28	32
8	Grand Total	42	53	61
Pivot

 

[KHughes687]

Thanks VoG. I'll give that a go. Someone else has just pointed out I could have used a simple SUMIF formula too! I think I just need to go home and have a lie down and forget about today!

Thanks again. Appreciate the fast response.