Paste Every Nth Row

**HangMan** · 05-26-2013, 12:19 PM

I have a large data sheet, around 8,000 rows. I need to be able to copy the data and paste it into a client provided template. The template is already pre populated with entries on every other row, so I need to be able to copy my data and paste it into every other row of the template. I've attached a simple example to show how this needs to work.

I also need the flexibility to be able to enter a different number, via a user entry box, because sometimes, the client supplied templates will have two rows of pre populated data, so I would then need to paste my data evey third row and so on.

Is there any way to achieve this?

Many thanks

**Ron Coderre** · 05-26-2013, 01:42 PM

Here's a basic macro to try:

Please Login or Register  to view this content.

Is that something you can work with?

**HangMan** · 05-26-2013, 02:14 PM

Hi Ron,

That seems to work perfectly, many thanks. Is there any way of being able to introduce a user entry dialogue window, to allow the entry of the actual groupings. The data entry will eventually need to be done by people who are non VBA savy, who wouldn't understand how to edit code.

Thank you for your help...