Unfortunately I have to reopen this topic since I founded, that I forgot for one very important condition in my request.

As I already mentioned your macro code works perfectly but I have to update my request as follows:

- I have to see items in negative values but once subtotal of appropriate item in column "J" is negative. Just fyi column "J" represents customer number. Could you pls help me to update your code?