kadrleyn
Member
Hi,
In this tutorial, we firstly created an Excel spreadsheet by entering to the Data sheet which staff sold how many products on which date .
After creating the sheets showing the sales amount of the personnel, a new menu item called Add-Ins is added to the Worksheet Menu Bar. Later , a drop-down list is added to the new menu item by the macro. In this drop-down list all sheets of the workbook are listed. Thus, user can be easily navigated between the sheets of the workbook.
I hope it will be useful for users.
https://eksi30.com/daily-sales-report-with-excel-vba/
In this tutorial, we firstly created an Excel spreadsheet by entering to the Data sheet which staff sold how many products on which date .
After creating the sheets showing the sales amount of the personnel, a new menu item called Add-Ins is added to the Worksheet Menu Bar. Later , a drop-down list is added to the new menu item by the macro. In this drop-down list all sheets of the workbook are listed. Thus, user can be easily navigated between the sheets of the workbook.
I hope it will be useful for users.
https://eksi30.com/daily-sales-report-with-excel-vba/