I generated a pivot table from my excel data set (roughly 100 fields and 1000 unique records and really should be an Access project in the future). After I have put all of the pivot table filters/creterias in, I will double click to drill down on certain things. I really don't need to see all of the information on the drilldown (ie: I really need about 10 of the 100 fields).
Is there a macro that would let me delete all of the unneeded columns after the drill down? Just to keep in mind, I might have to add a few more column in the data set so using the macro recorder to delete certain rows probably won't work for me.
Thanks
Sam
Is there a macro that would let me delete all of the unneeded columns after the drill down? Just to keep in mind, I might have to add a few more column in the data set so using the macro recorder to delete certain rows probably won't work for me.
Thanks
Sam