VBA Question | Insert rows and split cells based on line count in a cell

[dutch245]

Good morning!

I have a data set that comprises one record per row in excel, however the cells in columns M and N may be one line of data, or may grow into several lines of data.

For the rows that have multiple lines of data in cells M and N I have been manually going in and adding blank rows to equal the number of lines in cells M and N - copying the data from columns A through L into the blank rows, and finally splitting the lines in cells M and N into all of the rows I've inserted.

I have found information online to:

• Get count of lines in a cell
• Insert blank rows into my data set

I'm looking to know if anyone knows of a guide, or can provide the VBA code to search my range of data for rows with multiple line cells M and N, insert blank rows as needed, copy cells A thru L into the blank rows, then split M and N accordingly?

Hopefully this post is clear enough to understand, if not please let me know!

Thank you,

 

[sijpie]

No need for a temporary variable:

Sub RenameSheet()    
    
  ActiveSheet.Name = "DJL | " & Replace(Format(Now, "mm.dd"), ":", "|")

  
End Sub

or

Sub RenameSheet()   
    
  ActiveSheet.Name = Replace(Format(Now, "mm.dd"), ":", "|")
  ActiveSheet.Name = "DJL | " & ActiveSheet.Name
  
End Sub