After taking a tipple of the sweet nectar of macros on MS Excel here and there over the years, I decided a few months ago to go right ahead and take the plunge – use the rudimentary skills I learned making a reset button on my Imperia Excel sheet (set six cells equal to zero) at The Workplace.

This unleashed a Beast of frenzied, jerky self-teaching of VB for Excel. Getting right into it without a clue, I basically did this by recording macros, going into the code and copy-pasting all over the place. I recorded a copy, recorded a select-all, and pasted them into another macro I recorded to create one single macro. Then, I copy-pasted this main macro 12 times to do it every month for the entire year. I did what I needed to do, and got practical results.

No, I know that this is NOT the most efficient way to go about it. It’s like taking a club to the computer. And the code was the opposite of sexy.

Have made progress since those first few attempts, am more familiar with the code and have taken to consulting a book about it. There is an entire universe of things to learn still.

Perhaps I should learn loops next… Yes, I’ll do that soon as I’ve got the time… In the meantime, copy-pasting January – December will do just fine.