Delete all blank worksheet using Personal Macro
In this article, we have create the a Personal Macro to delete all blank worksheet from active workbook. You can use this for the workbook wherein you have multiple worksheet
Blogs
Excel VBA based Application with SQL database
In this article, we have created a Excel VBA based Application with SQL database. We have used ADODB connection to connect the database. In this application we have created Insert,
Dynamic Performance Chart in Excel
In this article, we have created dynamic Performance Charts. We have used excel shapes and Doughnut Chart here. To make these charts dynamic we have used Form control option buttons. Dynamic
Bulk File Creator in Excel VBA
In this article, we have created an automation to create the bulk files for Excel, Word and PDF. Here we have used a school mark sheet template. This is a
Export all Excel Worksheets in separate PDF files
In this article, you will learn how to Export all Excel worksheets in separate PDF files. In this macro we have used FileDialog in VBA to get the folder path.
Goal Seek in Excel using VBA
In this article, we have used a Goal Seek Goal Seek in Excel using VBA to get required minimum sales to meet the Sales % target using VBA. You can
10 Useful Pivot Table Tips
Pivot Table is useful and power full feature available in Excel. Learn the below given 10 useful Pivot table tips in Excel- 10 Useful Pivot [caption id="" align="aligncenter" width="813"] 10
Data Driven 3D Table in Excel
In this article, we have designed a data driven 3D table in Excel. We have used Linked picture and excel shapes to create this table. You can use this in
Timer Chart Visualization in Excel
In this article, we have created a beautiful data driven Timer Chart visualization. You can use this chart to display KPI metrics like Service Level, Quality Score, Sales conversion etc.
Dynamic Conditional Formatting in Excel
In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights