Delete Row ABOVE

D

Donna

How would I delete rows if

If b2="Void"
Then I would like for it to delete Row 2 and Row 1?
 
A

Ashish Mathur

Hi,

In column C, use the foll. formula in cell C1
=if(or(B2="Void",B1="Void"),"delete",1). Copy this all the way down. Now
select the column and press Ctrl+G > Special > Formulas > Text. This will
select all the cells which have delete. Now you may delete these rows

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select and delete levels of a document 2
Size of RTF increasing 10x after minor edit 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Remove Identical words 0
Changing row background from external program 0
Dealing with a Pivot Table (when I don't want to) 0
Match and delete rows on two different sheets from reference numbers 4
Need Help with a VBA subroutine 0

Top