I have a spreadsheet with data in Sheet 2 Range (A4:K6) that I want to
copy to Sheet 2 Range (A7:K*) (* being the variable that will change
each time the macro is run. The * is determined by the number of rows
of data in Sheet 1). I have accomplished this task by using loops, but
it takes too long to complete the macro. I am now trying to have the
data copied to the specified range in one paste.

Sean