Formula or Macro

  • Thread starter Thread starter Eán
  • Start date Start date
E

Eán

I need to write a formula or macro that would allow me to do the follow:

If cells $F$3:$F$70 contain "Very High" and cells $G$3:$G$70 contain "Very
High" in sheet1 I need the whole line A:K to be repeated on sheet2.

How do I do it please?

Thanks
 
Untested

For i = 3 To 70

If Cells(i, "F").value = "Very High" And _
Cells(i, "G").Value = "Very High" Then

NextRow = NextRow + 1
.cells(i, "A").Resize(,11).Copy
Worksheets("Sheet2").Cells(NextRow, "A")
End If
Next i
 
Back
Top