Multiple IF Condition

[madhuchelliah]

Hello Guys, I have my sales report in a table starts from column I7 to M7. In I column i have my product name, in J column order status and in M column quantity of the product. My requirement is IF cell content in J column reads ordered and M column cell content reads quantity as 5, then the corresponding product name should be listed from O7 in O column one by one. I required in macro format not in formula. Please help. Thank you.

Example:
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD="align: center"]I
[/TD]
[TD="align: center"]J
[/TD]
[TD="align: center"]K
[/TD]
[TD="align: center"]L
[/TD]
[TD="align: center"]M
[/TD]
[TD="align: center"]N
[/TD]
[TD="align: center"]O
[/TD]
[/TR]
[TR]
[TD]Book[/TD]
[TD]Ordered[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]Book[/TD]
[/TR]
[TR]
[TD]Pen[/TD]
[TD]Ordered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Note[/TD]
[/TR]
[TR]
[TD]Note[/TD]
[TD]Ordered[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]Pencil[/TD]
[/TR]
[TR]
[TD]Pencil[/TD]
[TD]Ordered[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]Ruler[/TD]
[/TR]
[TR]
[TD]Eraser[/TD]
[TD]Ordered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ruler[/TD]
[TD]Ordered[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, how about something like this:

Sub m()
Dim c As Range
For Each c In Range("I2:I" & Range("I" & Rows.Count).End(xlUp).Row)
  If LCase(c.Offset(, 1).Value) = "ordered" And c.Offset(, 4).Value = 5 Then
    Range("O" & Rows.Count).End(xlUp).Offset(1).Value = c.Value
  End If
Next c
End Sub