Thanks for the hint! Yes, I thought this could be done with PQ. There are actually many ways to accoplish this, the easiest one is probably is through SUMIFS funciton. You can just insert this function in each line (with the code as criteria) and delete all the rows that return 0. I'm just learning VBA, and this is why I wonder how this can be done with more advanced code.
Bookmarks