Many times it happens when we are not able to sort our data as per our requirements. We have to take some support column to sort the data. For example if you have month wise data points. Month name is in text format like Jan, Feb, Mar etc. If data is not sorted by month and we have to sort the data by month name. We would not be able
In this article you will learn how to rename the multiple files available in a folder. In the previous post I have explained you how we can get the files information in a excel sheet. We will use the same method to get the current file names of given folder. Once we have the file names in the excel sheet then we will give new name in another excel column
In this article you will learn how to get the files information from a folder like File Name, File Type, File size, Last modify date etc. in excel sheet. We will use the file system object to create this. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime
Rating meter is very innovative and informative chart to show the Process or Portfolio level health in five buckets – Worst, Bed, Average, Good and Best. We have calculated these buckets on the base below given table. [caption id="attachment_7173" align="aligncenter" width="221"] Bucket Calculation[/caption] Below is the snapshot of Rating Meter Chart. We also have displayed a small smiley symbol in the center of rating meter. Shape and color of this
In the previous article you have learnt how to Excel to PDF converter using VBA. In this article you will learn how to convert multiple Word files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor >
In this article you will learn how to convert multiple Excel files into PDF file using VBA. This is quite useful and easy macro. We have used File System Object method here. To use the file system object you need to add “Microsoft Scripting Runtime” Reference. To add this Reference go to Visual basic editor > Tools > References > Microsoft Scripting Runtime [caption id="attachment_7149" align="aligncenter" width="459"] Add Reference[/caption] We
After creating the Digital Clock, we have created a beautiful Analog Clock. This stunning Analog Clock we have developed using Pie Chart and Doughnut Chart. To calculate the formula automatically, we have used below given code. Option Explicit Sub Start_Clock() Dim sh As Worksheet Set sh = ActiveSheet sh.Range("N1").Value = "Start" x: VBA.DoEvents If sh.Range("N1").Value = "Stop" Then Exit Sub Application.Calculate GoTo x End Sub Sub Stop_Clock() Dim sh As Worksheet
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Click here to download this Excel workbook. Watch the step by step video tutorial:
This is the version-2 of Stylish Butterfly Chart. In the “Stylish Butterfly Chart – Version 1”, we created it vertically. In this chart we will create the butterfly chart horizontally. These both the version of Stylish Butterfly Chart can be used according the space available in your dashboard or presentation.
We are back with one more interesting chart that is Stylish Butterfly Chart (Version-1). This is useful for the comparison of two team on different KPIs. You can use this in your dashboard or presentation to make it eye catching. Below is the data points which we have used to create this chart. [caption id="attachment_7121" align="aligncenter" width="370"] Data Points[/caption] Below is the Stylish Butterfly chart- [caption id="attachment_7122" align="aligncenter" width="622"]
