Copy and insert rows based on user input

Hi everyone,

I found the following code which I believe partially does what I need:

Please Login or Register  to view this content.

What I need to do is have rows 9 - 18, columns B - S copied and pasted below each other based on the number the user inputs in the MSGbox. So if the user enters 3 in the Msgbox, B9 - S18 will be copied 3 times one below the other starting at B19.

Any ideas?

Thanks!!

Does this help?

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Hi John,

That worked much better. The only thing now is that there is content below the range of cells, so I'd actually need the entire 8 rows copied down, not just the contents of the range. Manually, we would just insert 8 rows starting at row 17 and copy the range in that. Any ideas?

Thanks,

Try:

Please Login or Register  to view this content.

Hi John,

Thanks very much. The range is now copying perfectly below depending on the number entered by the user. However, they are being copied over the data in the cells that's already directly below it. I'm thinking we need to specifiy how many rows are inserted first below 19 and then copy. In that way the data that's already below 19 will simply shift down as the rows are entered. Would that work?

Maybe:

Please Login or Register  to view this content.

Thanks so much, John. Works great.

You're welcome. Glad to help out and thanks for the feedback.