Cumulate items macro

[andreyGMP]

I made a macro that should cumulate the items from a Timesheet Export: for example if the value from cell (2,21) is the same with the value from cell (1,21) then sum the amount from cell (2,12) to cell (1,12) and delete the entire row of cell (2,21).

Untill now my macro does something, but it's not 100% what i want because i have to run it more times to delete all the duplicate items. The question is how to do so the loop will continue to next combination without stopping ? (if there are more then 2 same items)

Please Login or Register  to view this content.

Cumulate items macro- example (1).xlsm


Thanks a lot !

[andreyGMP]

Hello again,

I manage to solve this, so i will post the solution here, maybe someone else will need and use it:

I thought that the problem was that it deleted the rows into the loop, so first we will sum the hour amounts (from duplicate items) at the first item, and at the duplicates will put 0 hours. Then we write the description in the corresponding cell of first item with ";" separator. And after this loop we create another loop for deleting the items with 0 values at the hours column. This is the code and is working good (maybe will need some adjustments to be faster- sort and delete all 0 itemes in the same time etc):

Please Login or Register  to view this content.

File:
Cumulate items macro- example (1).xlsm

[tigeravatar]

Hello andreyGMP,

Thank you for posting your solution!