title: Copy selected data from one worksheet to another with Excel VBA
body: <p>I am trying to copy selected data from one worksheet to another with Excel VBA. As you can see in my pictures when the <strong>value</strong> is a <strong>0</strong>, the value of the <strong>test_Point</strong> should be written in another worksheet. So I want to <strong>copy</strong> the <strong>test_Point</strong> value of each cell where the <strong>value</strong> is 0. </p>
  
  <p>Source data on <code>Sheet1</code>:</p>
  
  <p><a href="https://i.stack.imgur.com/UNSxr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UNSxr.png" alt="enter image description here"></a></p>
  
  <p>Expected result to be put on <code>Sheet2</code>:</p>
  
  <p><a href="https://i.stack.imgur.com/E2sCn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E2sCn.png" alt="enter image description here"></a></p>