Daily Sales Report With Excel VBA

Personnel Based Daily Sales Report Template

          ✔ In this tutorial, in Data sheet we firstly created an Excel template by entering which staff sold how many products on which date .

At the top of Data sheet, we added two VBA button controls called Report and Delete Report Pages.

          ✔ When the user presses the Report button, new worksheets are created according to the names in column B, and the product sales made by each personnel by date are listed in these worksheets .

         ✔ 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. 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.

Really ,a useful Excel Macro .