The GetPivotData function returns data from a pivot table. It can retrieve summary data from a pivot table as long as the summary data is visible. The syntax for the GetPivotData function is:
pivot_table is generally a named range that has been set up to point to the pivot table. name is the name of the summary value that you wish to retrieve. For Example: Let's take a look at an example. Below we have an Excel spreadsheet that has a pivot table on the sheet called "Pivot Table". We've set up a named range called team_count that references this pivot table ('Pivot Table'!$A:$C).
|
||||||
|
Visit our busy book shop, were you can find latest books for beginners as well as advanced excel users.
Spreadsheet 123 Spreadsheet Software Development
See Spreadsheets for:
a.Hotel Management b.Personal Budget
c.Corporate Finance d.Rating Calculation e.Real Estate and Mortgage
f.Web Calc