title: Excel VBA - how to find the next largest substring value
body: <p>I have a single column range of values as part of a table. The values in this column are groups of sequential strings such as:</p>
  
  <pre><code>ABC-001
  ABC-002
  XYZ-001
  EFDDGE-001
  ABC-003
  XYZ-002
  ABC-004
  </code></pre>
  
  <p>What I need to do is assign a value in the next row that is the next value in the whatever the group is.</p>
  
  <p>Example:</p>
  
  <pre><code>If the next item is an "ABC" item, I need the value in the column to be ABC-005
  If the next item is a "EFDDGE" item, I need the value in the column to be EFDDGE-002 etc.
  </code></pre>