|First a posting tip:|
It does not appear that you followed the instructions at the bottom of my response related to posting data in this forum. Please click on the blue line at the bottom of this post and read the instructions found via that link before posting any more example data in this forum.
re: "sometimes it could be every 50th line, 55, etc"
What will determine how many lines to move?
re: the line above should reflect the first alpha letter of the next column
What if the "next column" contains data that starts with different letters?
Your example output has nothing next to Annamaria Dr 4. What causes that to happen and how would the code know not to move anything into that cell?
If you are moving every 50 or 55 row from Column A to Column B, what happens to the rows that the data was moved from? Are those rows deleted so that Column A becomes shorter?
Please remember that we can't see your workbook from where we are sitting nor can we read minds. You know exactly what your data looks like and what you want to do with it. You need to be very clear about what you are trying to acomplish so that we can offer a solution that will work.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.