Insert rows based on a value in another cell

Hi Experts,

I have looked into the Forum for prior posts but I seem to be missing how to do what I am trying to do. I need to copy values from Sheet1 and Paste to Tab Formatted, with a blank line inserted after a given number of lines. The value of lines needed before the insert is listed on tab Formatted in cell F1. I can add all of the other formulas that I am using to fill in the rest of the values but I am stuck on getting the lines inserted to the Formatted tab. Please feel free to point me to a prior thread, but I have looked. Also, please feel free to ask for more info, I have attached the file I am working on.

Thanks again

Hi Mike,

I am looking for it to count down six rows and insert a blank row and then count down the next six and insert a blank row. So after every six lines of data there is a blank. I also realized I need to put a formula on three columns on the inserted rows, but I can look into that on the forum. See below to see if that helps. Thank you very much

1
2
3
4
5
6

7
8
9
10
11
12

13
14
and so on

Sorry for the confusion. I want to copy from Sheet1 to Formatted, I have the macro for this. I then want to insert a blank row based on the number entered into F6 on the Formatted tab. This is where I am having trouble getting my macro to insert the line after each record based on F6 value. I think I have the rest of the macro(s) working but just need help on the Inserting a blank row piece. Once again, sorry for the confusion. I was talking about the whole thing but only needed help with the insertion piece.

Hi Mike,

First, thank you very much the code works perfectly. Since what you put together works much better than what I am trying to do I thought I would attach the file I am trying to format and see if you have a way to make it work. I have highlighted everything in yellow that needs to be setup. I put all of the formulas on the lines that you have being inserted. I also realized that the first line has a drop in the line item values (see Clolumn O and P) so I think I need to shift the cells in P to AA down one after the inserted row. Please let me know if this is too much to ask of you or if you are able to help please let me know what more info you need. I cannot begin to thank you enough for the code you have already sent.

Thanks

Highlighted file

Perfect. Thank you again. I will leave you alone now .