How To Write an Excel Macro to significantly help your Corporate Budgeting Process

Excel macros are not difficult to write and manage. Harnessing Excel macros will make your corporate budgeting process easier.

“But I am not a programmer!” I hear you say. Programming may not be in your job description but if you hate doing repetitive tasks in Excel, it’s time to learn. Start by trying out a simple macro. Once you begin to apply them and you see them replacing your manual processes – then you will soon wonder just how you managed to survive without them!

Here are the steps to write your first macro. In my example I am using one of the first macros I ever wrote. It’s quite handy because it consolidates data from different workbooks and spreadsheets. You can then use the SUMIFS() function once the data is together.

Don’t Panic! In the immortal words of Hitchhiker’s Guide to the Galaxy (no, you don’t suddenly become a sci-fi nerd when you start using macros), don’t panic. There is no need to panic. If you ever get stuck with a macro, Bing.com and Google.com are there to help you out. Initially, you will find you spend more of your time searching for answers and tweaking the code and feel a little unproductive. But rest assured that next time it will be much faster and easier.

Keep it simple. Don’t try to replicate an application like insightsoftware. The example I am about to show it is simple but a time saver.
Open Excel. I am using Excel 2016. If you have a different version of Excel, macros will still work the same.

From your Customize Quick Access Toolbar menu select More Commands.

Check Developer in the Main Tabs list on the right and click OK.

You are ready to go!

Your next step is to hit the Record Macro button.

That is the easiest way to get started. Excel actually writes the macro for you.