Originally published at: http://www.howtogeek.com/162975/geek-school-learn-how-to-use-excel-macros-to-automate-tedious-tasks/
One of the more powerful, but seldom used functions of Excel is the ability to very easily create automated tasks and custom logic within macros. Macros provide an ideal way to both save time on predictable, repetitive tasks as well as standardize document formats – many times without having to write a single line of code.
To use macros you first need to enable the Developer tab which is disabled by default.
You can do the basics from the View ribbon including running, recording and editing VBA code. When you need to use Form and ActiveX controls you'll need the Developer ribbon.
So, I am trying to create macroses (which never works), everything is fine with the recording but when I change the sheet and apply the key combination, the macro brings the graph from the 1st (the one I used to record) data sheet.
Here is the case -
I have data on many sub-sheets in a document that is in the same cells.
After I do the first sheet and recorded my actions, I would like to apply the same actions to the other sheets.
Oh, I'm using Home and Student 2007 which might explain why all macros were disabled by default.
Hi Geeks, interesting tool those Macros. I am using Mac Excel 2008.
- The macro function appears not to be working is that correct anyone?
- The way the example is described, is only useful in the case of large numbers of identical data sheets with numbers occupying the exact same field positions, is that correct?
- An alternative way of tackling this would be to set up an excel sheet as per the example (without recording), save it and protect it except for the data fields, in a fixed location as a template, and then record a macro that opens the (rough) data sheet whenever it comes in, copy-pasts these into the template, do a 'Save As' and stop recording. Is that right?