Generate Underlying Data From Excel Pivot Table

by Bill Dowling 2. April 2013 09:57
The following code will extract the underlying data that makes up a Pivot Table in Excel. Manually, if you double-click in a cell in the Total Row, you will get a new worksheet (tab) containing all the data that made up the Pivot Table. This routine will find all Pivot Tables, locate the total row and create a new worksheet (tab) with it's data. &n... [More]



About the author

Bill Dowling has been a VB and .Net programmer for as long as he can remember.

Month List