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 .
![79333 79333](https://chandoo.org/forum/data/attachments/79/79425-3555612bed5be0e280c738ecbc8a8086.jpg)
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.
![79334 79334](https://chandoo.org/forum/data/attachments/79/79426-333d59fc7790ee17940ee8de2ee236e3.jpg)
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 .
![79333 79333](https://chandoo.org/forum/data/attachments/79/79425-3555612bed5be0e280c738ecbc8a8086.jpg)
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.
![79334 79334](https://chandoo.org/forum/data/attachments/79/79426-333d59fc7790ee17940ee8de2ee236e3.jpg)
I hope it will be useful for users.
https://eksi30.com/daily-sales-report-with-excel-vba/