Sure I have heard about Macros before, but just as comments and knew that Excel had that tool but it was, as so many other tools in Excel, something that is there but have no idea of its uses.
I have to agree with many people out there that say that Excel is a super powerful tool, how did we survived without it? Poor people before worksheets, doing everything manually…YUCK
A guy at work is quite a wiz in Excel and tough me the Macros tool option. Basically what is does is that it records all the movements and operation you do in a worksheet so that you can, afterwards, just click on an icon and see how everything is done by itself just the way you did before.
With the change of ERP I am in charge of migrating all the info from the old system into the new crappy one, so that means working a lot with Excel and doing and redoing the same thing over and over. I was getting good at it, but still it was time-consuming. This guy showed me Macros and now I record only once the process and then…just one click!
It’s so awesome that right now its working on the background while I write on my blog…It means that I am still earning my pay, just that the PC is doing it for me and I can use the free time to write…wow ain´t that precious?