Do you filter pivot tables one item at a time and copy paste and send to different people? Stop doing that. Use this macro by Dr Nitin. It saves you all the trouble and gives you readymade pivot files. You just have to mail them. Pivot table is preserved. No need to paste as values. Each pivot has only the filtered data. So security is also maintained.
Download the add-in and macro code from here
Related videos
Amount to Words Excel Macro for India – 16 parameter Function
Apply Excel chart templates – Macro
GetPivotData macro – Copy from pivot and paste as GetPivotData
