Macro to conditionally delete a row

[AToyama]

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

 

[Von Pookie]

Yes, it is possible.

What is the condition for deleting the row(s)?

 

[AToyama]

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]

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