Microsoft Excel Macro - Enhance your productivity!
Macros in Microsoft Excel can be useful for automating repetitive tasks and streamlining your workflows. A macro is a series of instructions that you can record and then play back to perform a specific task or series of tasks.
Macros can save you a lot of time and effort, especially if you have to perform the same tasks repeatedly or if you have a large amount of data to work with.
I have created 3 Macros that will greatly improve your productivity in both personal and work!
Macro 1 - append worksheet
If you have multiple files (E.g. 10000) with the same columns that you want to combine into a single file, instead of open 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.
Look at these 3 sample files. Let's say I want to copy 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!
This is the output.
Macro 2 - insert photos
If you have multiplies photo that you want to insert automatically into a designated column of excel file, this macro will do it perfectly for you!
Look at these 5 photos which one wish to put into a column of excel file.
This is the output.
Macro 3 - Mail Merge and spilt file
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. However, some times, we need to break the files based on a particular column of the excel.
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.
These are your source merge files.
Mail Merge word source file
Mail Merge excel source file
This is the output.
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! Would you want to do this manually or automatically?
- Zone1.docx contains Customer1, 2 and 3
- Zone2.docx contains Customer4, 5, 6,7 and 8
- Zone3.docx contains Customer9 and 10
Zone1.docx
Zone2.docx
Zone3.docx