Macro to delete rows where Values are oposite & Equal Col H

**Howardc1001** · 10-06-2020, 04:36 AM

I have tried to write code that where values are opposite and equal eg 150 -150 in Col H and the account number is the same or if no account number, then those rows are to be deleted

I cannot get it to do this

It would be appreciated if someone could kindly amend my code or provide new code

Please Login or Register  to view this content.

**sintek** · 10-06-2020, 06:51 AM

I have tried to write code

that where values are opposite and equal eg 150 -150 in Col H and the account number is the same or if no account number, then those rows are to be deleted

So what is it...
Must it be deleted if no account number...And
Must it be deleted if the Acc no's are the same and the balance is zero...Cancels each other out
What if the balances cancel each other out and the Acc no's are not the same...

I think you need to be more specific...

**Howardc1001** · 10-06-2020, 07:07 AM

Hi Sintek

I need the macro to do the following

1) where there is no account number and values opposite and equal then those rows to be deleted
2) Where account numbers are the same and values apposite & equal, then those rows are to be deleted
3) Where balances cancel out but account numbers not the same then no action to be taken

**sintek** · 10-06-2020, 07:11 AM

So in your sample all remains the same...Nothing needs to get deleted...

**Howardc1001** · 10-06-2020, 07:15 AM

My apologies Sintek

I have uploaded a new sample workbook

**sintek** · 10-06-2020, 08:20 AM

Try this...

Please Login or Register  to view this content.

Same...

Please Login or Register  to view this content.

**Howardc1001** · 10-06-2020, 12:07 PM

Thanks Sintek

Code works perfectly

**sintek** · 10-06-2020, 01:24 PM

Glad I could assist...

**Howardc1001** · 10-07-2020, 02:44 AM

Hi Sintek

I tested your code on additional sample date this morning and get run time error no cells were found and code below ae highlighted

Please Login or Register  to view this content.

Kindly check & amend your code

thanks

Howard

**sintek** · 10-07-2020, 02:55 AM

That is due to your file setup been different...this file has more than two criteria matches...
i.e. AR01 has 6 entries...Code was written for two opposite entries only as per original sample and requirement...

**Howardc1001** · 10-07-2020, 03:36 AM

Thanks for letting me know

I will amend your code just to delete values where the values are opposite & equal

**sintek** · 10-07-2020, 04:01 AM

I will amend your code just to delete values where the values are opposite & equal

That will not be possible...Need a different code...don't have time this week...Will see if I can hop on board next week unless some else can solve for you...

**Howardc1001** · 10-07-2020, 04:22 AM

Thanks Sintek. No huge rush-Always appreciate the help on from you and others on this forum

**sintek** · 10-09-2020, 07:20 AM

Not sure how big your dataset is...

Please Login or Register  to view this content.

**Howardc1001** · 10-10-2020, 07:10 AM

Hi Sintek

Thanks for the help

The dataset is not large (maximum rows 500)

**sintek** · 10-10-2020, 07:13 AM

K cool...that loop code will suffice...Not sure if the order of data is important...Did not bother with adjusting sort to original entry order...

**Howardc1001** · 10-11-2020, 11:48 PM

order of data is not important

**sintek** · 10-12-2020, 02:24 AM

Thanks for rep +

Macro to delete rows where Values are oposite & Equal Col H

LinkBack

Thread Tools

Rate This Thread

Display

Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Re: Macro to delete rows where Values are oposite & Equal Col H

Thread Information

Users Browsing this Thread

Similar Threads

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

I need a macro to delete rows when cells and adjacent cells equal another pair

VBA/Macro to delete cell values if equal to another cell

[SOLVED] How to use a macro to remove rows whose values in column A equal to blank spaces?

Need a Macro to delete all rows containing values less than or equal 300 in column A

Delete rows with cell values equal to or greater than current week number

Macro to delete entire rows where O2:O does not equal a date

Bookmarks

Bookmarks

Posting Permissions