title: How to Find the next value if more than 1 matched Excel VBA
body: <p>I am trying to make the this search to be able to find the next value if more than 1 matched.
  <img src="https://i.stack.imgur.com/vSPyT.jpg" alt="enter image description here"></p>
  
  <p>Right now, all it can do it shows the first matched.</p>
  
  <p>Basically, if I press button "NEXT" Then it just go to next matched value.</p>
  
  <p>My logic: I think I must do subtract the total range from the current range but I have trouble with this.</p>