Row Deletion based on condition.

  • Thread starter Thread starter Manish
  • Start date Start date
M

Manish

I want to delet a particular row based on a particular condition which has
multiple conditions.
Please asist ASAP as this will be a great help for me.
 
Hi,

I think your going to have to provide a bit more detail:-

Could this be any row?
What are the conditions?

Mike
 
You will have to.............

1. Use VBA

2. Provide much more detail on particular condition or multiple
conditions.


Gord Dibben MS Excel MVP
 
Hi Gord,
I appreciate your reply,
i have a table as below

Student Name Pass/Fail Exam
Manish Fail VB
Gord Pass Java

the above table is an example of my job sheet it has thousands of records i
want to run a macro where i can Delete all the rows for the Students who
gave JAVA exam and failed by a single macro.
i know this can be achived my filtering but then again i have delete the
row after selecting. I want some thing as below.......

if(exam = "JAVA" and Pass/Fail="Fail", then delet the particular row)

I appreciate your help.
Waiting for your response.
Regards,
Manish
 
Assuming your data is in columns A through C

Option Compare Text
Sub delete_fails()
Dim rng As Range
Set rng = ActiveSheet.Range(Cells(2, 3), _
Cells(Rows.Count, 3).End(xlUp))
For Each cell In rng
If cell.Value = "Java" And _
cell.Offset(0, -1).Value = "Fail" Then
cell.EntireRow.Delete
End If
Next
End Sub


Gord
 
Back
Top