Row Insertion

[arehman1289]

Hello
I have a sheet in which I ask the user to input the number of branches. Based on this input Id like to write a VBA that could dublicate the next rows and formulas in it. As an example in the attached image, if the user enters 3, i would like to duplicate the next 4 rows (highligted in yellow), 3 times.

I have very basic skills at the moment in the developer TAB and I am learning at the moment. Any help would be highly appreciated.

Thank you

 

[arehman1289]

What row is it copying FROM and what row is it copying TO?

It is copying from row 10 to 17 in a worksheet thats why the default increment is 7.
However the reference values in the formula are from another workssheet, thats why I would like them to increment by 15. Only the C cell values. If required I can private message the file ?
Thank you loads for your support.

For the second part, ill follow your advice and implement it later on.

 

[Joe4]

However the reference values in the formula are from another sheet, thats why I would like them to increment by 15.

Like I said, you should post that to a new question, since it is a new question, but be sure to include all the impoertant details.
But be sure to include all details (i.e. exactly what range you are copying from/to). That could impact on how they develop the solution.

The general rule of thumb is this:
1. If you have a directly-related follow-up/clarification question on a reply in your original question, you can post it back to the same thread.
2. If you have a new question (even if it is on the same code/problem you are working on), it is best to post it to new thread. That way it will appear as a new question, and you will get more "looks" (and there is no guarantee that the person who helped you with the first issue has the answer to your second, so you do not want to assume that).