copy lines a specified number of times

[Kim_J]

I have a user form. All of the generic data is entered in, but there are instances when the data must be entered on multiple lines, except for one value which would change. I hate having to copy down the lines every time manually.

I added a command button on the first form (Add additional payers)
that will add all of the generic data once, and then bring up another form that just asks for the enrollment number and the number of additional payers to add, and then gives combo boxes with the list of payers.


How would I code this to:

Find the enrollment number on the worksheet
Copy range $b2:$q2 down X number of times (the value in the second textbox)

I think I've got how to add the rest of the boxes onto the lines.

I appreciate any help, I'm still pretty new with this. I can attach an example but I don't know how. Thanks.

[Leith Ross]

Hello Kim_J,

To attach a file when you post, scroll down the page to Additional Options and click the button Manage Attachments. Just follow the prompts after that.

Sincerely,
Leith Ross

[Kim_J]

Invalid file?

[Leith Ross]

Hello Kim_J,

The file must be zipped before you cab attach it.

Sincerely,
Leith Ross

[Kim_J]

Aha, got it, thanks.

So basically what needs to happen is there must be a row on the "data" tab for each separate enrollment(payer)
However, the same company might have several enrollments.

Instead of copying manually, or filling out the same form 9 different times, I would like to be able to have it look up the enrollment number it gives when the first payer is added, and then copy cells in column b, and then d-i the number of times in column j, right underneath. I think I can figure out how to get the other payer names in there, I have no idea where to go with this part.

Thanks in advance to anyone who can help!