What I am looking for is a formula that uses functions intrinsic to Excel -- that is, NO VBA CODE!!!! (which is why I'm posting here and not in Excel Programming) that will return the range of the pivot table. Not the data table that feeds the pivot, I want the actual pivot table. It doesn't matter if it takes a couple of cells to build the formula or if the resultant formula is huge. Is this possible?
Bookmarks