This site under reconstruction.
In my last post I mentioned that I had created some VBA programs to update my nightly pulling in data. Now it’s been about a week and is really is fast. Today I just finished up the last macro that I wanted to create and I will be testing it tonight, but already, the speed…
A couple of posts ago, I outlined some ideas on how you can creatively use Excel to solve some problems or to automate your work. That post took so long to create I decided to break it up into two posts. This one will be the second post. So, here’s a few more examples….. Idea…
Note: This post took forever to develop. Creating examples took a lot of out me so I’m thinking of doing the second half next weekend. Over the holidays I was thinking over the conversations I had with others about using Excel and it got me thinking about ways I use Excel that others don’t. It…
Sometimes simple is all you need. Last month I was asked to help out in automating an activity that was needlessly taking up time. Usually when people come to me, they think “program” but sometimes formulas or pivot tables will do the job just as well. In this instance, they needed to restructure some reporting…
A few weeks ago, I did a post “Playing with Data Query” on pulling in data from websites such as Wikipedia or government sites. I believe most sites give data in the form of tables. Wikipedia or the government site showing you the names of House of Representatives or Senators are good examples where you…
You must be logged in to post a comment.