title: is there a way to sort data from an imput value
body: <p>i have 3 columns in excel with the values Name / City / Birthday i try to create an inputbox where i can type in the Name and a second one where i will type in the birth date so that the result that will show up in the 'th column will be City+Birthday only for the name used in the first imputbox.
  i tried this but it didn't work</p>
  
  <pre><code>Sub fill_next()
      For i = 2 To 10
          If InputBox("vam", "val") = Range("A" &amp; i).Value Then
              Range("E" &amp; i).Value = Range("B" &amp; i) &amp; InputBox("enter number", "value baliz")
          End If
      Next i
  End Sub
  </code></pre>