Macro to conditionally delete a row

AToyama

New Member
Joined
Feb 10, 2005
Messages
9
Hello,
I am brand new to Macros and have only used the record function so far so please bear with me. Is it possible to add a procedure to my Macro that would allow a row to be deleted automatically if a specific condition is met?
Thanks in advance for your assitance,
Amy
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

AToyama

New Member
Joined
Feb 10, 2005
Messages
9
The spreadsheet is a member database and this macro is to format the data for a mail merge. I have several different conditions which would cause the row to be deleted, for example "delete all members with membership type = X" or "delete all members with source code = X".
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,454
Hi Amy, welcome to the board.
Some questions to get an idea of your layout...
1. What rows are you wanting to search through for these conditions?
2. What columns will the delete conditions be found in?
3. What are all the conditions you'd like to look for?

Dan
 

Watch MrExcel Video

Forum statistics

Threads
1,122,519
Messages
5,596,635
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top