Macro to insert blank rows based on data above

Basically what I am looking to do is create a macro to add a number of blank rows depending on the data above it. I have included a sample of what I have and what I want to be able to do. I want each tech number to have 12 rows regardless of whether there is information in them or not. Sheet1 of the sample is how it looks when sent to me, Sheet2 is how I would like it to look after the macro is done running. I will be sent over 200 rows of information daily and I need the information to look as I have it in the sample for another macro I am using to pull the information. This would be a great help. Thank you in advance.

Matt

now I have this code I pulled from a reply to another question that will shift the data in row c down two rows, but I would like it to be able to insert blank rows, I think I might be able to figure out how to do the rest

Please Login or Register  to view this content.

Hello MattLinkus,

Here is the expanded version. I have already added this to your workbook which is attached.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thank you very much Leith, this is very close to what I'm trying to achieve. This code shifts the data in column c down, but what I would like to do is add a full blank row. I changed ".Insert Shift:=x1ShiftDown" to ".EntireRow.Insert"

Hello MattLinkus,

I wasn't sure if that's what you wanted to do. Thanks for the feedback.

Sincerely,
Leith Ross