Create a slicer in an existing PivotTable
Click anywhere in the PivotTable for which you want to create a slicer. On the Analyze tab, click Insert Slicer. In older versions of Excel, click the Options tab, and then click Insert Slicer. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer. Click OK.A slicer is displayed for every field that you […]
Auto Save Excel File After Cell Value Change
A macro-enabled excel file can save automatically when changing any cell value. See the below given VBA code for autosave : 1. Right-click the sheet tab that you want to autosave the workbook after entering new data, and then choose View Code from the context menu, in the opened Microsoft Visual Basic for Applications window, copy and paste the […]
BMI Calculator
Calculate Your Body Mass Index. Body mass index (BMI) is a measure of body fat based on height and weight that applies to adult men and women. Enter your weight and height using standard or metric measures.
Suicide of An Excel File!
This is not a story, an amazing VBA code to protect your highly confidential excel file from theft/miss use. If you have developed a workbook which you want to self-expire by a certain date, such as a demonstration model or containing information or usefulness that will be outdated, you can program a workbook to delete […]
Panappayattu: A North Malabar Financial Model
What is Panappayttu? Panapayattu is a network of money exchange which can be seen in some parts of Calicut and Kannur district of North Malabar. “Panappayattu is a unique network system of exchange of money in which the financial needs of a person is met by a group of people on the basis of a […]