Useful Macros - 12
Copying The Chosen Numeric Values To The Other Page
In the previous examples, the columns that contain non-numeric values were copied .
We will copy the numerical values that comply with criteria in this template .
There are numeric values in Column I.Now let's copy great values from 20.000 in Column I to other pages.
Using code as follows :
"For i = 1 To a
If Val(Cells(i, 9)) > 20.000 Then
Sheets("Data").Rows(i).Copy sh2.Rows(last)
last = last + 1
End If
Next i "
