Alternative to Pivot Table in Excel
In one of my previous posts (How to read data from Pivot Tables using VBA), I talked about using the getpivotdata() function in VBA to read values from a Pivot Table. In this article, we are going to look at building an alternative to pivot tables. Let's begin.
Pivot tables are an immense help while working with data sets – they sum up the data into a small, neatly organized space. You can pick and ...
Translate
LATEST POSTS
- Prevent Users Ctrl Break (ing) Your VBA Code During Execution
- Multiple Scale Chart – Adding Customized Scale to Each Category in a Chart
- The Content Aggregator Called Excel
- Table Formula in Excel (Something I didn’t Know Till Yesterday)
- Multithreaded VBA – An Approach To Processing Using VBScript
- Named Range – A Few Quickies
- So How Many Of These Excel Shortcuts Do You Know, Punk ?
- Volatility Chart in Excel – Lessons in Chart Design From NY Times
- An Excel Chart’s Journey Across Versions
- A Big Thank You
- Square Bubble Heatmap Chart
- VBA IF Function – Using IF, ELSE:, ELSEIF, IF THEN in VBA code
- Treemap Add-In For Excel – Treemap Software Demo
- Data Validation List in Excel – Create Drop Down List Using Data Validation in Excel
- Data Validation in Excel – How to Use Data Validation Feature in Excel
- Treemap in Excel – Coming Soon
- VBA Select Case – Using VBA Select Case Statement in Excel
- Control Chart in Excel Using VBA – Six Sigma Control Chart Code & Software
- One Axis Frequency Distribution Chart in Excel (Download & Template)
- Custom Format to Catch Numbers Appearing as Text
