Day: June 19, 2020

Table of Contents In this article we will learn how to turn off GetPivotData option while referencing a pivot table in excel. This usually happens while referencing a cell from the pivot table. Creating a reference from another cell appears like =B4 but if the reference is done from a pivot table then GetPivotData function gets added…

Table of Contents In this article we will learn how to filter cells having bold font formatting in excel using a simple VBA code Steps to insert code Open the Visual Basic Editor using Alt + F11 Goto Insert Tab Click on Module Paste the below code into module Code Using the function Create a…