week++
I pretty much spent this week Excelling, or at least attempting to. I created a database of all of their teleconsultation records with macros that automatically generated useful summaries whenever it was updated with session attendance logs.
After the first day, I was impressed with how I picked up VBA so easily (I had learned some VB 6 back in high school). I had written code to separate parts of a single name, search the total attendance for duplicates, delete the repeats, and display unique names alongside counts and the dates attended. I later learned this was called a filter, and excel had this feature built in.
Two days later, the same thing happened again. Except this time, I had programmed a pivot table. Or actually like 6 different pivot tables. Oh well, at least I know how to program in VB again.
2 comments August 4th, 2007