title: Find row number in column and move data Excel vba
body: <p>I hope you guys can help me. I have an Excel sheet with data that I want to copy some some values and move them to another column. </p>
  
  <p>The data currently is something like this:</p>
  
  <pre><code>A           B
  ...
  20:00:00    2456
  21:00:00    2147
  22:00:00    5623
  23:00:00    1247
  00:00:00    3549
  01:00:00    1234
  ...
  </code></pre>
  
  <p>I have data from several days, and when I found the string "00:00:00" which is the beginning of another day, I want to copy the prior 24 values to the next column. </p>
  
  <p>The result should be something like this:</p>
  
  <pre><code>A           B       C      D
  ...
  20:00:00    2456
  21:00:00    2147
  22:00:00    5623
  23:00:00    1247
  00:00:00            3549
  01:00:00            1234
  ...
  22:00:00            2418
  23:00:00            3245
  00:00:00                   3549
  01:00:00                   5437
  </code></pre>
  
  <p>I've started to try found the row number of the values equal to "00:00:00", save them in an array and then make the difference between row value(i+1) "00:00:00" and row value(i) "00:00:00"</p>
  
  <p>Thanks and regards,
  Daniel Duarte</p>