Formula or Macro

[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

 

[Bob Phillips]

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