If you need Excel to automate a repetitive task in Excel you may need to create a macro. A macro is a way in Excel, to record steps and replay them at your convenience.
- Macros can be very simple: changing a date format for a column.
- Macros can be also very complicated and involve coding and web access etc.
- All macros are first recorded, then saved, and finally replayed when you need them.
- The official Microsoft documentation can be found here.
In the video below, we show how to create, save and replay a simple macro. The macro changes the format of dates for a given column.
Note: On YouTube, you can find tons of videos on macros for specific use cases.