The issue is as follows:
there's data in sheetA (the workbook is always the same).
By running the macro based on criteria, I sort data out onto different sheets in the workbook.
What could be possibly done for a macro when the same condition occurs several times to sum it up instead of dividing it into many rows?
e.g. In sheetA there's plenty times of "chocolate" for a determined period and when macro is run, it splits "chocolate" up into several rows in another sheet (chocolate 20, chocolate 30 etc.). What can I do to sum it up and have "chocolate 50" in one row?
Thank you!
there's data in sheetA (the workbook is always the same).
By running the macro based on criteria, I sort data out onto different sheets in the workbook.
What could be possibly done for a macro when the same condition occurs several times to sum it up instead of dividing it into many rows?
e.g. In sheetA there's plenty times of "chocolate" for a determined period and when macro is run, it splits "chocolate" up into several rows in another sheet (chocolate 20, chocolate 30 etc.). What can I do to sum it up and have "chocolate 50" in one row?
Thank you!
