Here is a list of Macros I have written for various Office tools. Usually we feel that any repetitive task requires a macro. That is a wrong concept. Typically, repetitive tasks indicate that the method you are using is inefficient. Usually there is an efficient way to do the same job – which eliminates the repetition.
Macros should be written to create capabilities which you need but the product does not offer that feature. All the macros described below fall in this category.
Macros and related articles
- When NOT to record a macro in Excel
This is not a macro. But it explains an important concept.
The idea is to use macros to extend the application and add missing functionality.
Often, macros are created for features that already exist. This happens due to lack of awareness.
- Excel – Amount to Words macro
A comprehensive macro to convert numbers to Words.
Available only for Indian Rupees. 16 configurable parameters. Extremely flexible.
- Excel – Macro to Explode Pivot table by Filter Field Items
Very useful to create separate files based upon items in the filter area of pivot tables. The output is a working pivot table with filtered data only. This way you give the ability to use full features of pivot and prevent removal of filter to maintain confidentiality.
- Excel – Paste as Pivot – New way to use Pivot table data
Creates bulk GetPivotData statements based upon selected cells in pivot data (value) area. Very useful for accurately referring to pivot values outside the pivot table for creating custom reports.
- Excel – Scribble a line and generate data (and chart)
A very interesting tool where you draw a freehand line and the data for it is auto-generated in Excel
- PowerPoint – Arrange Pictures instantly – great for arranging logos…
- PowerPoint – Split text into words or characters
- PowerPoint – Split and Animate tables by cell
- PowerPoint – Run multiple presentations easily using this add-in
Do you have some requirement which needs a macro?
Post it as a comment. If it is generically beneficial, I will try to create it for you.
Is there a tool/spreadsheet that can help me keep a log of number of words typed daily on my laptop across multiple word files automatically?
Sir, Thank you for the tools shared which will be helpful in due course. I need your help in Macros. I have a file that tracks certain action items or activity to be completed by certain people by certain date. I need a Macro that can on the Run date, search the document for due dates, check if dates have passed by and the Action status is still Open (not closed) and trigger an email to email id of person responsible with the Action update and seek updated status. This is a monthly activity and would help if a Macro is developed to simplify this
Technically, we can always write a macro to do what you want.
That can be an AutoOpen macro and that file can be scheduled to open using shell script.
The problem is, using Excel for tasks management is not the right approach.
Look at Outlook Task Delegation. That covers what you want + more.
Read this article for details https://efficiency365.com/2014/02/04/never-delegate-work-using-email-use-outlook-tasks/
Hi Sir , thanks for the contribution made , can we have Macro where we drill down a pivot and instead of having the drill report on a separate sheet , it will go and show the relevant rows in the Main original source data itself. so we can directly edit any thing in main data itself and just refresh the pivot.
What you are asking for is not possible.
Just maintain the main pivot table and run the macro each time.
If you create a separate copy of the data, then it is not a central pivot table anyway.
If you want to drill down data easily and explore it intuitively, import the same data into Power BI desktop and use the Distribution Tree visual.
It is amazingly useful.
i have got one macro from internet where in double clicking on any particular cell in pivot will take you to its underline data sets, but i am not able to modify it
Double click showing raw data is a native feature in Pivot Table.
There is no macro for it.