Copy/Paste Macro

[JChandler22]

Please see the attached file for clarification:

Attachment 11707

This is a very abbreviated version of my actual worksheet. There are 100+ tasks (sections), and I would like to include a command button at the top with a macro that will insert a new task (or section) wherever the user wants in the worksheet (i.e., between 2 and 3, or between 3 and 4, etc).

Currently the code I have set up - which I copied and unsuccessfully modified from another source - is:

Please Login or Register  to view this content.

The problem I'm having is getting the macro to paste the template from below back up top, wherever the user has initially selected a cell.

Any help is greatly appreciated! Thanks.

[royUK]

Your download isn't working so I'm not completely sure what you are doing. Try this, enter the range that you are copying

Please Login or Register  to view this content.

[JChandler22]

copy_paste.zip

Hopefully that works a little better? Please take a look and see if you might be able to help! Thanks...