title: Find within an existing find loop in Excel Macro
body: <p>I have a excel spreadsheet where I have values in a form format, I need to convert them into tabular format. example - </p>
  
  <pre><code>Project ID/Name:    3001    Miscellaneous Improvements  
  Location:   This is Project Location.   
  Description:    This is the project description. This is the project description. This is the project description. This is the project description. This is the project description. This is the project description. This is the project description. This is the project description.
  Justification:  This is the project Justification. This is the project Justification. This is the project Justification. This is the project Justification. This is the project Justification. This is the project Justification. This is the project Justification.
  Duration:       Q1 2013 to  Ongoing     
  Status:     This is some status
  </code></pre>
  
  <p>Each block starts with Project ID/Name, however, Description and Justification can vary according to the size of text they have. All the headings are in Column A. If I use Find for ProjectID - and use offset at a fixed length it works but if Justification and description are bigger or smaller they don't fall in correct place. Please help. </p>