Copy values from one range and paste in another with some slight modifications

[Grilleman]

So I'm trying to copy data from row 3 through 20 and paste it repetitively beginning at row 21 based on the value of an input box. However, with each paste iteration I want to:

a) clear the pasted data in columns L & M
b) increment the values in the column K by 1

To illustrate what I'm looking for, I've attached my workbook which includes a sheet entitled 'Holes'. This worksheet displays the results of my code as it exists now (see below). The tab entitled 'What I want' displays the results I'm trying to achieve.

Please Login or Register  to view this content.

[jdelano]

Try this code, I like to stay away from copy and pasting:

Please Login or Register  to view this content.

edit: removed pasterange and colorindex vars that aren't used any longer