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 .


Read more ...

Excel Customizing Right-Click(Context) Menu

Context Menu In Excel


In this template, with right-click menu :
You can enter the date to the selected cell. 
 You can easily convert strings to uppercase-lowercase-propercase
 You can navigate to the selected sheet with ComboBox.
 You can sort the cells as ascending /descending.

You can use this right-click menu example into your own templates.


Read more ...

Create Pivot Table with Excel Vba



You can create an Excel Pivot Table using VBA in template. Also you can copy pivot table into Ms Word.


Read more ...