Button to copy/paste to last row

I have attached a copy of the worksheet I am trying to manipulate. I have named a range, B7:T11, Insert. I would like to insert a control button to copy that range and insert new sections at the end of the data. It doesn't have to be that specific set of information but when you look at the attachment, you will get the idea. This is for an audit package where there may be 100 workers that need to be added and the summary rows at the bottom will need to include the added data.

Any help is appreciated. I have tried recording macros and manipulating the code but I really don't know much about coding.

Hi Clee7093,

I looked at your file. You should make sure you remove it and post one that doesn't have someone's SS # listed within it. That person might be a little upset if she knew...

On your workbook, you have data in rows 39 through 47 already. Does that mean you want B7:T11 to be copied below that data or do you want it to show up after row 36 but before row 39? It would be easier to move the data currently in rows 39 through 47 into it's own area outside of columns A through T.

Ok, can you repost a copy then? I already closed the one I had and didn't save it.

Hi Clee,

Try this out. Let me know if it suites your needs or not.