Copy Range X times Based on User Entered #

Hello all,

I am looking to create a macro that copies data from A3:D3 and paste it X times on a new speadsheet (X: this number is entered in cell cell J3 by the user).

All of the light orange on the Check's Sheet would be filled in by the user and the Server Pay Sheet would be populated with 1 line for each server (J3) working the event.

I would like the sheet to look like "Should Look Like This" sheet. And i want the Macro to run 1 line at a time if possible (So I can run it each time I have a new event).

Thanks in advance for any assistance!

Test Copy.xlsm

It is real handy to attach a file that needs a password.

While you're looking for your password, try this on a copy of your workbook.

Please Login or Register  to view this content.

Run it from the "Check's" Sheet.

Sorry guys, the password is "password". They both work for what i'm looking for so thank you.
One last thing would be is there a way I can run it and have it only copy over new data? For example if I ran it with the current Check's sheet, and then I added 1 more row below with new data to the Check's Sheet, could it only copy over that 1 row of new data?

Thanks for your help

Clear the "Server Pay Sheet" first would be the proper way to go in case something is changed in the existing data.
Run the macro again on all data.
If that is not possible, let us know.

Just in case you want to go with clearing "Server Pay Sheet" first, something like this would probably do it.
This code can be run from any sheet. You don't have to be in "Check's" sheet

Please Login or Register  to view this content.

Here is another one. Includes the servers.

Those are some great macros! I think everything is setup and I am good. Thanks for everyone's help.