Supercharge your Life
One of the key themes of my blog is to improve life. Hence using productivity tools will helped to improve your work life/personal life too.
I have shared these tweets on Microsoft Excel Macros that I have created few days ago via Twitter. Hence, I thought I should share with my blog user too in case you are not my follower on Twitter.
Let me extract what I have posted in Twitter
Careyourpresent(💙,🧡)
@careyourpresent
End of 2022, let me share something nice!
In the corporate world, Microsoft Office suite is undeniable one of the most important tools.
Out of the Office suite, one of the most powerful tools would be Microsoft Excel.
In excel, we can use Macros to automate many tasks…yet…
Careyourpresent(💙,🧡)
@careyourpresent
Most people still don’t know how to use it.
In its most simple form,
A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes to automate and save precious time!
Careyourpresent(💙,🧡)
@careyourpresent
Simply go to the Developer Tab -> Record Macro to record a task that you keep on repeating.
For example, copy and paste certain rows to certain rows, filter with list of conditional formulas etc.
Macros can also be edited with Visual Basic programming language (VBA)…
Careyourpresent(💙,🧡)
@careyourpresent
After you have recorded the macros, you can simply click “Visual Basic” to edit the code directly to perform higher function.
In my corporate life, I have met problems that I have managed to automate and increase my productivity – finishing my work with a click instead of hours
Careyourpresent(💙,🧡)
@careyourpresent
I have created 3 macros after many hours of coding that would definitely solve your problems and improve your productivity.
Let me share them with you. I did the hard work so that you don’t have to!
Let me explain the first Macro – Append Worksheets.
Careyourpresent(💙,🧡)
@careyourpresent
If you have multiple files (E.g. 10000) with the same columns that you want to combine into a single file, instead of opening each file at a time, then copy and paste slowly. You can use this Macro to do all these steps with a click of button only.
Careyourpresent(💙,🧡)
@careyourpresent
Let’s say I want to copy and paste all of them into 3 files. Instead of open, close, copy and paste each at a time. You can do so with a click of a button!
Look at these 3 sample files which I want to copy and paste them into a single file.
Careyourpresent(💙,🧡)
@careyourpresent
This is the output with the click of a button.
If you have 10000 files to copy and paste, this macro will do for your with just ONE CLICK instead of hours! Isn’t Macro Wonderful?
Careyourpresent(💙,🧡)
@careyourpresent
Let me share the 2nd Macro: Append Photos.
Application forms are used in many settings. Usually, we will use Microsoft Forms or Google Forms. In these forms, we may have a field to ask the users to upload photos or pictures.
How do you insert these photos beside each entry?
Careyourpresent(💙,🧡)
@careyourpresent
The method that most will use is click the cell that you wish to insert via click “Insert” -> “Pictures”. Then you can edit the picture size accordingly to your liking.
But what if you have 10000 photos? Do you still want to manually insert pictures? It will take hours!
Careyourpresent(💙,🧡)
@careyourpresent
Fear not! We can use this Macro and finish with a click of button.
For examples we have 5 smiley photos to insert into column E of an excel file.
We just need to insert the file name of the photos into column D -> Then click run macro and your job is done in few seconds!
Careyourpresent(💙,🧡)
@careyourpresent
This is the output with a click of button.
Of course, 5 photos you still can slowly manualy insert. Imagine if you have 1000 photos! Do you really want to insert the pictures manually?
Careyourpresent(💙,🧡)
@careyourpresent
Let me share the3rd Macro: Mail Merge and spilt file.
Mail Merge is a very common tool that many people are using. We can pull multiple column data of an excel file into word files and generate word files as output.
Careyourpresent(💙,🧡)
@careyourpresent
However, for mail merge, you can only break your result files based on the number of rows of data that you have selected in your excel source file. But sometimes, we need to break the files based on a particular column of the excel to group certain data….
Careyourpresent(💙,🧡)
@careyourpresent
This macro will break up your generated mail merge word file into multiple files with different file name once there is a change in data of a particular column of the excel.
For examples, these are your source files. For every change in file name of column G, you want a new file
Careyourpresent(💙,🧡)
@careyourpresent
Of course, you can do it manually. But with this macro it is just one click of a button.
With just a click of a button, there will be 3 files generated, break by column G (zone information). Imagines how powerful this is if you need to break 1000 files!
Careyourpresent(💙,🧡)
@careyourpresent
This is the output with a click!
Zone1.docx contains Customer1, 2 and 3
Zone2.docx contains Customer4, 5, 6,7 and 8
Zone3.docx contains Customer9 and 10
Careyourpresent(💙,🧡)
@careyourpresent
Can you see how powerful Macros are for automation?
I have done the hard work to automate for you so that you don’t have do it yourself!
With these macros, it will definitely improve your productivity!
Why spend hours to do something where you can just do with a click?
Careyourpresent(💙,🧡)
@careyourpresent
For a limited time only, these macros will be available at a very cheap cost to you that would save your precious time!
Simply click the link below to purchase!
https://careyourpresent.gumroad.com/
Please feel free to let me know if you need any further clarification about these macros.
Careyourpresent(💙,🧡)
@careyourpresent
I have been through the hard way and know the wonder of automation that will help you save time!
I will continue to create more tools to help you improve your productivity.
Do also share with me if you are looking for any other particular macros that would help you!
Thanks for reading my article. I truly appreciate that you have visited my site!
If you have any comments about this article or have any other topics that you want me to cover in my site, please feel free to leave a comment at the end. Thanks!
For those who are interested in my articles, please join the others to sign up for my free newsletter to has my newest blogposts sent to your mailbox for free!
For real time exclusive updates on market news/life (especially Crypto markets where the news move fast, important news will be shared directly via tweets or telegrams), do also join the platforms below and engage with other like-minded people!
- Telegram Group (Chat with me and other like minded people!)
- Telegram Channel (Get the latest updates on the markets/life!)
- RSS Feed
You may also contact me via [email protected].
If you’re looking referral codes, do check out my referral and ebook page. Give it a try and who knows? You might end up loving these platforms! To be absolutely fair to all the readers, I am definitely using all these companies and they are useful to me! Likely will be useful to you too!
At the same referral and ebook page, you can also download my free ebooks and other free resources:
For quick references to these resources, you can see below.
- Ebooks and other useful resources on enhancing productivity (Investment, Excel, Notion etc). Currently most of it are free at this moment (subject to change).
- MoneyOwl: You can use this 6SHU-93MC to get free grab vouchers and highly safe liquid cash fund account.
- Trust Bank – a new digital bank. A unique partnership backed by Standard Chartered Bank and FairPrice Group. You can get free bank account with no minimal balance and credit card with no annual fee ever. KNDBPEPT.
- FSMOne: P0413007. Good account to keep liquid cash in autosweep and to purchase investment at low fee.
- Hostinger: You can use this link for hosting your new website.
- Crypto.com: Use my referral link https://crypto.com/app/h92xdfarkq to sign up for Crypto.com and we both get $25 USD 🙂
