Thread: Copy and paste the template to the next portion of the screen, VBA

Hi there,

I have this template file for fiscal year 11-12, but would like to add the flexibility to add new template when new fiscal year starts.

What I want:

1) hit that button
2) Excel will copy the first 11-12 fiscal year table and paste it starting on row 15. (so it is one row after the previous year's total row, and all subsequent tables have exact same format)
3) what's in C4 to Q13 should not copy over every time the button is clicked. So their contents should be cleared.

I guess we can just do a manual copy and paste, but I just thought I wanted to play around with this macro and see where it takes me.

How do I define the new range in where template is pasted? Using a for loop to find where the last row is prior to copying and pasting?

Any ideas?