mastery over Excel

[juldea]

So 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

Comments

[juldea.livejournal.com]

*hmmmm*

I can wrangle Access too... Never played with Filemaker.

Not being bugged by management = doubleplusgood.