Macro to delete rows where Values in Col D sum to zero

**Howardc1001** · 02-07-2023, 10:05 AM

I am looking for code to delete all rows where the sum of the debits and credits in Col A sums to zero

Your assistance in this regard is most appreciated

**beyond Excel** · 02-07-2023, 11:48 AM

.
- In column A you have dates.
- In column B you have codes that are not repeated except in a single case.
- And column D is full of positive numbers except two.

I ask: Are you sure you uploaded the correct workbook?...

In any case: Could you indicate which row you think should be removed and why?

**Howardc1001** · 02-07-2023, 01:12 PM

thanks for the reply

The items in Yellow and blue sum to zero and those rows must be deleted-see attached fie

**beyond Excel** · 02-07-2023, 04:12 PM

Did you try Solver?...

**Howardc1001** · 02-08-2023, 06:05 AM

I will try Solver. Have not used it for a long time, but will read up on how to use it again

**Howardc1001** · 02-08-2023, 08:05 AM

I have used Solver and it works perfectly

**beyond Excel** · 02-08-2023, 11:16 AM

Originally Posted by Howardc1001

I have used Solver and it works perfectly

Well done.

Macro to delete rows where Values in Col D sum to zero

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete rows where Values in Col D sum to zero

Re: Macro to delete rows where Values in Col D sum to zero

Re: Macro to delete rows where Values in Col D sum to zero

Re: Macro to delete rows where Values in Col D sum to zero

Re: Macro to delete rows where Values in Col D sum to zero

Re: Macro to delete rows where Values in Col D sum to zero

Re: Macro to delete rows where Values in Col D sum to zero

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to clear rows whee ageing in Col L is below 120

Macro to delete Rows where Values add up to zero In Col H

[SOLVED] Macro to delete rows where sum of values sum to zero

[SOLVED] Macro to delete rows in Col B where the values are zero

[SOLVED] change macro to delete values in rows

Macro to delete rows containing values

macro to delete rows with a range for values

Bookmarks

Bookmarks

Posting Permissions