Home > Uncategorized > Copying The Chosen Numeric Values To The Other Page

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 . For example ; 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)) > 20000 Then

Sheets(“Data”).Rows(i).Copy sh2.Rows(last)

last = last + 1

End If

Next i “

numeric value copying

Download Working Example

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: