If condition match then delete entire row by vba else do nothing

**MoldyBread** · 07-09-2020, 11:48 AM

Hi Experts,

I am looking for a macro details are mentioned below & plz see the sample file

Thnx For the Help

If column J has BUY then compare column K with column with column H & if column K is Greater than column H then do nothing else delete entire row
If column J has SELL then compare column K with column with column H & if column K is smaller than column H then do nothing else delete entire row
If column J has DELETE then delete entire row by vba

**oeldere** · 07-09-2020, 02:01 PM

Non VBA solution

L2 =IF(OR(AND($K2>$H2,J2="BUY"),AND($K2<$H2,J2="SELL")),"","delete") and drag down.

After that filter on delete in column L and delete the rows.

**MoldyBread** · 07-09-2020, 02:03 PM

Thnx Sir for showing ur great interest in solving this problem

But
I am looking for VBA macro only sir

**ikboy** · 07-09-2020, 10:43 PM

Please Login or Register  to view this content.

**jindon** · 07-09-2020, 11:06 PM

Originally Posted by MoldyBread

If column J has BUY then compare column K with column with column H & if column K is Greater than column H then do nothing else delete entire row
If column J has SELL then compare column K with column with column H & if column K is smaller than column H then do nothing else delete entire row
If column J has DELETE then delete entire row by vba

try

Please Login or Register  to view this content.

**MoldyBread** · 07-10-2020, 10:26 AM

Thnx Alot Jindon Sir for helping me in solving this problem Sir
Have a Great Day
Problem Solved

If condition match then delete entire row by vba else do nothing

LinkBack

Thread Tools

Rate This Thread

Display

If condition match then delete entire row by vba else do nothing

Re: If condition match then delete entire row by vba else do nothing

Re: If condition match then delete entire row by vba else do nothing

Re: If condition match then delete entire row by vba else do nothing

Re: If condition match then delete entire row by vba else do nothing

Re: If condition match then delete entire row by vba else do nothing

Thread Information

Users Browsing this Thread

Similar Threads

Delete entire row based on certain condition

delete empty entire row with condition

[SOLVED] VBA to delete entire row based on condition met

[SOLVED] Delete the entire row if condition didn't match

[SOLVED] Macro to delete entire row on a condition

Delete entire row on condition

[SOLVED] Can I delete an entire row if condition is not met?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions