title: Search an entire ROW for a date located in another Cell
body: <p>I am new to both stackoverflow.com and VBA within Excel, so go easy on me :-)</p>
  
  <p>I am looking to have a button in my excel sheet that when clicked, will search the entire or row 1 for a date (located in another cell). If it finds the date in a call in row 1, it will enter some text in the cell below it. If it doesn't find the date, it will add the date to the next free cell in the row and then add the text in the cell below that. </p>
  
  <p>I know I have asked a lot and I am happy to accept partial answers as I know how to do some of the aspect of this. For example the pasting of text and such. The part I am finding difficult is the finding on the date in the entire row 1 and then finding the next blank cell if no date is found.</p>
  
  <p>Any help or pointers will be highly appreciated!</p>
  
  <p>However, I would be even happier if I get a response, the person also explains how the code works as I am very keen to learn VBA and use it again in the future and not just copy and paste. </p>
  
  <p>Thanks in advance for any replies! :-) </p>