mastery over Excel
17 May 2005 13:26![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
juldeaSo it's not really anything cool in the long run, but dammit, it makes me feel awesome....
After a couple hours of trial and error yesterday and a couple this morning, and I have created a huge VB macro in Microsoft Excel to automate the boring, brain-numbing, time-consuming weekly task of formatting a particular report I get from the Finance Dept into something not just readable, but scannable.
So normally I go through this set of commands that takes half an hour or so every week... now I just hit the macro and it's all done within seconds. And I WROTE IT. Like... I'd record some commands as a macro, go into the editor, extrapolate from what I saw, and go on to add additional commands without needing to record them.
Hey, it's the little joys in life, y'know?
i r teh smrt
After a couple hours of trial and error yesterday and a couple this morning, and I have created a huge VB macro in Microsoft Excel to automate the boring, brain-numbing, time-consuming weekly task of formatting a particular report I get from the Finance Dept into something not just readable, but scannable.
So normally I go through this set of commands that takes half an hour or so every week... now I just hit the macro and it's all done within seconds. And I WROTE IT. Like... I'd record some commands as a macro, go into the editor, extrapolate from what I saw, and go on to add additional commands without needing to record them.
Hey, it's the little joys in life, y'know?
i r teh smrt