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