title: Problem while copying the columns based on the condition
body: <p>I want to copy only C and E columns values, but it is also copying D.</p>
  <p>I have written a code, That will copy the columns C and it corresponding elements of column E from &quot;REF&quot; sheet, when the E values are in between 0 to 60. Then it will copy it to the &quot;Cost&quot; sheet. But it is copying the C, D and E values also.  Please help me to solve the problem. Attached the code below</p>
  <pre><code>Private Sub CommandButton1_Click()
  
  lastRow = Worksheets(&quot;REF&quot;).Range(&quot;E&quot; &amp; Rows.Count).End(xlUp).Row
  
  For r = 2 To lastRow
  
      If Worksheets(&quot;REF&quot;).Range(&quot;E&quot; &amp; r).Value &lt;= 60 And Worksheets(&quot;REF&quot;).Range(&quot;E&quot; &amp; r).Value &gt;= 0 Then
      
          Worksheets(&quot;REF&quot;).Range(&quot;C&quot; &amp; r &amp; &quot;:E&quot; &amp; r).Copy
          Worksheets(&quot;Cost&quot;).Activate
          lastRowSheet1 = Worksheets(&quot;Cost&quot;).Range(&quot;C&quot; &amp; Rows.Count).End(xlUp).Row
          Worksheets(&quot;Cost&quot;).Range(&quot;C&quot; &amp; lastRowSheet1 + 1).Select
          ActiveSheet.Paste
          End If
          Next r
  
  End Sub
  </code></pre>
  <p>for datas refer the image</p>
  <p><a href="https://i.stack.imgur.com/AIGtU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AIGtU.png" alt="enter image description here" /></a></p>
  <p>When the button clicked it is started printing from the next cell where it printed recently</p>