Name Manager
Uncategorized VBA

Create Multiple Names using VBA in Excel

Our daily Excel activities can be automated using VBA. Here we have created an example of creating the Name range in Excel using VBA. Lets’ say we have below given data for which we have create the Names- [caption id="attachment_15185" align="aligncenter" width="1131"] Data to create the Names[/caption] We have created a button on the Home tab and assigned the macro on this button. [caption id="attachment_15183" align="aligncenter" width="559"] Additional button added
Dynamic Project Plan
Charts and Visualization Uncategorized VBA

Dynamic Project Planner (Gantt Chart) in Excel

Here we have created a beautiful and dynamic Project Plan (Gantt chart) in Excel. We have given a drop-down to change the weekly and daily view. There are 3 type of status has been given Pending, Completed and In-Progress. We have used VBA to change the View daily to weekly and visa-versa. This is password protect worksheet. The password is “1234” Below is the Weekly View- [caption id="attachment_4053" align="aligncenter" width="1183"]
Change % in Pivot Table

Change% in Pivot Table

In this article you will learn how to show Change% in a pivot table. For example, you have month wise sales and revenue in your pivot and you have to show the change% in sales and revenue in compare of previous month. We will show the change% as given in below image. [caption id="attachment_3677" align="aligncenter" width="538"] Change% in Pivot Table[/caption] Steps show the change% in a pivot table- Lets say