Remove lines based on cell value (remove lines in range, not entire row)

Hi,

I would like to find VBA code, which should remove cells in range "J-N" based on positive value in column N and Shift cells out. As result there will be listed only items with negative value).

Thanks in advance.

Thank you very much, my friend. It works for me as welll.

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?

Hi, partially it is ok, if I check the final amount as the result. But I need to keep also positive value for these customers.
Let me show it on example for customer# 391793197. Total amount is negative (-597,081.27) but for my purposes I have to see all lines since there are different GAxx indicators (GA02,GA30,GA1C), which are required for my next reporting.

Please Login or Register  to view this content.

Excellent! This is exactly what I need. I really appreciate your help. Thank you, man.

Try this

Please Login or Register  to view this content.

Hi jindon, thanks a lot for your effort, however I already got solution from excel_bat. Anyway thanks a lot for your support.