Based on the line:
"I would like the macro to copy from sheet 1 anything that has the country code 'ITA' and is greater than 0.185 Place into a sheet called Italy"
I have written the following code:
Dim lRow, lRow2 As Integer
Dim cell As Range
lRow = Sheets("Sheet1").Range("G" & Rows.Count).End(xlUp).Row
For Each cell In Range("G2:G" & lRow)
If cell.Value = "ITA" And cell.Offset(0, -4).Value > 0.185 Then
lRow2 = Sheets("Italy").Range("G" & Rows.Count).End(xlUp).Row
cell.EntireRow.Copy Destination:=Sheets("Italy").Range("A" & lRow2 + 1)
Then you say:
"then repeat the above and place the results in 'Italy' under the previously captured results"
This is done by running the code again.
But it's not clear to me what you want to do with sheet2. Ignore it?, search it as well?