|I'm not sure what you are trying to show me. Since the data is supposed to be pasted in Columns G:K, showing me blank cells in Columns A:F doesn't provide any insight into what is happening.|
What I need to know is, for example, how many columns of data were in Row 2? Based on how the code should work, if 3 lines were inserted I would guess (and I hate to solve problems by guessing) that you had data in Row 2 out to at least Column V but not past Column Z. Can you verify that?
In general, what the code should be doing is going out to the last cell with data in each row, determining how many columns there are past Column K and inserting enough rows so that the existing data can be moved - in groups of 5 - to Columns G:K as requested.
For example, data in Row 2 out to Column V would be 11 columns that need to be moved. 11 columns means 2 groups of 5 plus 1 extra, so we need 3 rows to copy the data in Columns L2:V2 to G3:K3, G4:K4 and the "extra" piece from V2 to K5.
Data out to Column BD would require 9 new rows since there are 45 columns beyond K, 45/5 = 9.
That's how the code is supposed work, but I'm not saying that is working correctly yet. Since I don't have your spreadsheet to work with, it's a little tough to provide the perfect solution unless I know some specifics about your sheet.
In addition, it appears that you have drop downs in Row 1. How will inserting rows impact your use of the drop downs?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.