Posted on March 2nd, 2009 by Joseph Harris
Typically when you use autofilter, the task bar at the bottom of your Excel workbook will say: “5 of 10 records found”. The five is your visible rows. In some situations the records found indicator will not be displayed on the indicator. This can happen when there are many complex formulas in your filtered results. [...]
Posted on February 26th, 2009 by Joseph Harris
Microsoft has issued a security advisory regarding possible vulnerabilities in Microsoft Excel 2007. According to Microsoft, a vulnerability in Excel 2007 could allow remote code execution which could in turn allow a remote user to gain the user rights of the system owner. The attack appears to primarily be happening when an attacker host a website [...]
Posted on February 26th, 2009 by Joseph Harris
Q: Joe, I have data in another workbook that I want to pull into my current workbook. How do I do this? Unsigned A: The easiest way to accomplish this is to open both workbooks. In the workbook you want to pull the data to, enter =, then go to the workbook you are pulling [...]
Posted on February 23rd, 2009 by Joseph Harris
For quick and easy up and down trend arrows in your dashboards and scorecards there is a simple solution…Marlett. If you do not know about this trick, you are probably unfamiliar with the Marlett font in Excel. Marlett was created by Microsoft for Windows and is used as the user interface font in many Microsoft applications. [...]
Posted on February 19th, 2009 by Joseph Harris
Today I came across a problem I see at least once or twice a week. I wanted to perform some analysis using an employee number. The output from one of my systems included the employee number with GLK_RDT at the beginning of the number. Since I needed the numbers alone, I needed to remove the annoying 7 [...]
Posted on February 18th, 2009 by Joseph Harris
Surfing the web today, I came across a great user defined function (UDF) called sumcolor(). This function sums a range of cells based on the color of the cells. My head began to spin with the possibilities! Below is the VBA for the function. If you are unfamiliar with how to install a UDF, here is [...]
