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