Excel Script Help

Microsoft Excel 2003 (full product)
May 4, 2010 at 10:33:15
Specs: Windows XP
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...!

See More: Excel Script Help

May 4, 2010 at 10:55:47
Please see this thread and let us know if the suggestion made there will work for you also...


Report •

May 4, 2010 at 11:07:49
Don't I feel a little foolish! Thanks DD. Yes, that sorted it. I've just wasted an afternoon trying to be "clever" when I could have used SUMIF...! GRRR!!!

Report •

May 4, 2010 at 15:34:13
Sometimes the simplest answer is the one we can't see.


Report •
Related Solutions

Ask Question