Copy the code to the respective module and confirm that the button is in action. One can increase the functionality of the worksheets by adding a VBA Command Button with its respective code. Office ...

Open Excel and click the File tab. Open the file in which you want to assign a cut/copy/paste macro or command button. Click the Developer tab, then click the "Insert" icon.

You then attach this macro to form controls such as command buttons. For example, buttons at the bottom of a sales sheet may copy columns of data to the corresponding section of a second sheet.