Wednesday, February 3, 2016

Copying The Chosen Numeric Values To The Other Page

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 "


No comments:

Post a Comment