Great page on referencing pivot table ranges – shows the range selected for each selection method used http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=154:referencing-an-excel-pivot-table-range-using-vba&catid=79&Itemid=475 Excel Chart
Read moreSelecting a theme is sooo easy and don’t they look great? Being a more functionally focused kind of guy, having
Read moreWordPress: initial thoughts… There is no shortage of content I would like to add to the net and thus the
Read more
Function to return a value for a specific id from a dataset with column headers in the first row (ie
Read moreSimple PivotTable report to show basic information about PivotTables in the activework. Useful in tracking down lost PivotTables and other
Read more
The puzzle: One hundred passengers are about to board a plane. The first passenger lost his boarding pass and decides
Read moreif condition ? true : false
Read moreScientific method, huh
Read moreSummary: Achieving our goals often means we need to modify our behaviour. Here I discuss some tactics to improve our
Read moreSummary: Our current system of governance has selected a PM with less integrity than the PM he replaced. This is
Read more