Insert Rows every X # of lines (details on tab 2) with formulas added on inserted lines

Hi Experts,

I have tried and failed to accomplish what I am trying to do.

I have attached a spreadsheet that I hope lays out what I am trying to do. The highlighting is just for reference and does not need to be included in any help provided. It was just the best way I could think of to show the before and after.

I have the before data set at the top and the Macro version at the bottom. The actual data set will have over 300k - 400k lines but I only included 10 for example purposes. I need the details entered on Splitting Details tab to be used when calculating the lines to go down before the insert happens. There then needs to be two lines inserted with different details needing to be included on each line. I entered comments in each field to try to help explain where it is coming from. I added a Red line because as you will see if there is no D's in Column A under a new H row it just needs to be deleted, it happens on the last row.

Please let me know what else I can do to help clarify what is not clear. I really do appreciate any help.

I would like to keep the Macro running all on the same Tab (Journal). I do not want to do a copy paste to another Tab.

Thanks again Experts.

Try this macro:

Please Login or Register  to view this content.