Published on February 07, 2018 at 06:07AM
Now you can click a metric in one of your Worksheet reports and be taken straight to the underlying data in a way that is easy to see.
Published on February 05, 2018 at 04:50AM
Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query
Published on January 23, 2018 at 01:42AM
Convert a date to the Financial Year (Fiscal Year) like '01/01/2017' = '2018'. Australian example used. Pure VBA without Excel formulas. Just the solution.
Published on August 30, 2017 at 07:00AM
Often you don't want to wrap an IF statement when you just want to turn a 0 result into another value such as blank
Published on August 24, 2017 at 06:20AM
Backup all the VBA codes to Git
Published on June 19, 2017 at 01:31AM
Copy this to your PERSONAL.XLSB to quickly switch between Worksheets on the ActiveWorkbook
Published on May 04, 2017 at 06:50AM
Useful to have as a button or invoke overtime to alert when you have forgotten to save
Published on February 15, 2017 at 05:59AM
A basic module I load to each project for shared functionality
Published on February 13, 2017 at 10:54AM
A simple function to return the row number of a table where a value is matched in a column. Like a VLOOKUP or INDEX MATCH for VBA.
Published on May 18, 2017 at 05:32AM
A short introduction to VBA by building something simple
Published on May 13, 2017 at 01:55PM
Go under the Excel hood by getting to know the Visual Basic Editor. The power house of the Excel workbook.