Recording Macros in Excel to Make Tasks Easier

Excel is a great program and it is even better when you get it to do repetitive or complex tasks at a click of a button. You’ve thinking but how is that possible when everyone has different requirements and tasks to do. That is where recording macros comes in handy. You basically get it to remember everything you do and then you can simply play it back when you need it. It creates the script or code for you, this code is called Visual Basic for Applications (VBA).

So there are many things you can do including setting up a spreadsheet, formatting it and then automatically printing it out, or perhaps you want to import some data, reorganise the information, format it, save it and then print it. These are just a couple of examples of where you can use this record macro facility. It is a nice feeling to just click a button and in the blink of an eye Excel has done it for you.

You can do so much more and stay tuned for more tutorials where you can add in interactivity and get Excel to make choices based on criteria that has been entered. Here are two videos to get you started. One is how to record in Excel 2003, the same works for Mac versions of Excel. The other tutorial is how to do it on Excel 2010 but the it works the same way in Excel 2007 and 2013.

Recording Macros in Excel 2003 (and Excel for Mac)

 

Recording Macros in Excel 2010…and 2007 and 2013

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Office 2010 and tagged , , . Bookmark the permalink.

One Response to Recording Macros in Excel to Make Tasks Easier

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s