So, individuals can create a link from the command button to a worksheet in your workbook. In this tutorial, we will explain how to use the Command button to navigate between worksheets in Excel.

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.

The branch office entered this information in an Excel worksheet named Hours Worked. Follow these steps to create the command button: Open a new form in Design view.