There’s more than one way to get your Excel macro to run when there’s an event like changes to your worksheet. You can use a special macro name which tells Excel when to trigger that code. By Office Watch reader, Howard Tanner There’s more than one way to get your Excel macro to run when […]
We look at an interesting bug in both Excel 2002 (XP) and Excel 2003. Thanks to Bruce N for reminding us about an interesting bug in both Excel 2002 (XP) and Excel 2003. As Microsoft puts it: “multilevel subtotals for data in Microsoft Excel 2002 or Microsoft Office Excel 2003, and you set the subtotals […]
When an Excel list gets big and complex, the issue of finding data in it, and extracting information from it, becomes important. We look at how to filter an Excel list to extract information from it. By Helen Bradley Excel is a great place to store lists and one reason is that the data is […]
