title: How to move cell contents down one cell when that cell has numbers in it?
body: <p>I’m trying to develop a VBA program to move cell contents and I only wish to use VBA (would like to add more to my program and so learn as much as I can using VBA). I need to move the contents down one cell but I’m not sure how does the program move contents down from one cell to the next if the next cell is full without overwriting it and then move that one down. I’ve included a jpeg of my excel sheet.
  I hope you can help.</p>
  
  <p>I'm trying to have the program move all the number sets down in the column E1:E12.
  I need the program to move the set of numbers (could be more than one set of numbers in the range) down to the following cell below it and increase the last number in the set (no limit to the count). So in the example of cell E1 (8-16) would move to E2 and become 8-17 (cell E1 would be blank when after the move). When sets of number are located in cell E12 they would move to E1 but still increase the last number and would go round and round (E1 to E12 and back). How does the program move contents down from one cell to the next if the next cell is full without overwriting it and then move that one down, if this makes sense. An example is cell E12, how does it move up to E1 if E1 is full but has to be moved? </p>
  
  <p>That’s it, thanks so much for any help.</p>
  
  <p><a href="https://i.stack.imgur.com/VTKS0.jpg" rel="nofollow noreferrer">my Excel sheet example</a></p>