Let us learn the Pivot Filter Split Macro. 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.
Contents
Update
- Now body text also contains the text “Report for (field name) – (item name)
- If Outlook is not running, email option will be inactive.
- We now use Outlook object model to send the mails.
If you want to customize this tool, you can edit the code in the XLSM file.
Download sample file
Download Add-In
Download the macro code
Outlook Security Warning Technical Details
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
