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

theglitch

New Member
Joined
Jan 3, 2018
Messages
5
Hi Experts,

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

I am not allowed to attach a spreadsheet, but I have one, 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.

The data does not need to start below the main set of data, it just needs to add the lines in the original set of data. The two sets of data were just to show the before and after. Hope that is clear

If I could figure out how to submit the spreadsheet I would :).

Thanks again Experts.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

theglitch

New Member
Joined
Jan 3, 2018
Messages
5
nevermind, I have made progress on this. Still having one issue. But this is resolved. Thanks to those who looked.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,916
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top