week++
August 4th, 2007
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.
Entry Filed under: Uncategorized
1. Sandeep | August 6th, 2007 at 4:10 pm
Nice work dude. I kinda understand your womens grant now.
Keep the posts coming, its a pretty good dictraction from work.
2. Dhruv M | August 8th, 2007 at 6:14 pm
you should totally use access databases to store this stuff if you don’t already. excel is really bad for storing a lot of data.