Home > Excel Tutorial > The Chosen Values Cutting And Pasting To Other Page

The Chosen Values Cutting And Pasting To Other Page

Useful Macros -10

Copying The Values In The Column That Match The Criteria To The Other Page

           The chosen values in any column are cut and transferred to other pages. While transfer  ,complete row are transmitted. Blank rows in the transfer page are deleted by the macro :

“Sheets(“Data”).Range(“C2:C” & Range(“C” & Rows.Count).End(xlUp).Row).SpecialCells(xlBlanks).EntireRow.Delete”

In this example,data were searched in the “Column C” .For this reason the loop is used as follows :

“For i = 1 To a

If Cells(i, 3) = “Gardena” Or Cells(i, 3) = “Malibu” Then

Number 3 in the code is “Column C“.

The number of cutted and transferred rows are shown on MsgBox.

  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: