title: Adding a row to Excel using Macros but only when the values in Column change
body: <p>If Column B contains week numbers, say "1" in rows 2-10, "2" in rows 11-14, "3" in rows 15-50 etc. How can I add a row each time the week number changes?</p>
  
  <p>The quantity of occurrences for each week number varies and sometimes the value would be "5-6"</p>