Search Not Just Numbers

Tuesday, 16 December 2008

Watch a macro doesn't hide a problem

When I tell clients that I can automate complex reporting in Excel so that it involves only a couple of clicks, they invariably assume I am going to use macros. Truth is, I hardly ever do.

Macros have their uses, i.e. to automate repetitive tasks, however in most cases the requirement for the repetitive tasks can be removed by better designing the spreadsheet.

If you can do what you want without macros, the spreadsheet tends to be more intuitive, easier to develop further and more flexible. Once a macro is used, users tend to be frightened to change anything in case the macro stops working.

Use of Pivot Tables in particular can automate a great number of reporting tasks far more elegantly than macros.

So, take a look at any spreadsheets that you use that incorporate macros and consider whether there is a better way.


  1. Based around 1830, a Europe Maison d’Horlogerie chanel replica sale has had your pleased reputation of developing different watches this routinely embody an excellent with virtue plus economical deluxe to get existence. Now, a brand’s three major louis vuitton outlet add typically elegant Linea for ladies, a sporty-elegant Capeland to get gentlemen, a incredible Hampton to get women and men, as well as Classima, ideal for all of times plus elevated by using innovative 2011 innovations. A brand’s innovative universe is already available by way of Sea side Basically a Hamptons, which will compares to to your reputable principles with spreading fake hublot watches, authenticity, plus laid back splendor. A Hamptons currently have empowered purse’s innovative lay claim: Everyday living concerns events. Fake dior ’s mandate has been to be a all-natural pet with life’s aplauded events, maybe a birthday bash and also husband's, your higher education, time period fake hublot watches, or perhaps relatives reunion, the type this warms all of our spirits in different customs plus for any region.

  2. This sort of woman tend to be interested, positive, communicative. hublot replica However there's a doctor believes, designer handbag can't differentiate which sort associated with individual a person goes in order to, since it not just rely on your own designer handbag designs, and so on. replica prada however Numerous elements should look into. Which sort associated with individual have you been goes in order to? fake chanel For any lady, that has powerful appreciation with regard to course as well as fashion, Hawaiian Clutches Manufacturers create a practical expense in order to the woman's self confidence. prada replica Not just will this manner item bring about the woman's character, but additionally this includes numerous practical benefits. dior replica Accurate which over the last, the buying price of the style clutches is actually constantly increasing, however simultaneously, this can make a very satisfying buy.