This bit of code will count how many formulas you have used in a workbook, will display a message box...
excel
IF Statement Using the IF Statement in the reportal expression builder is much like using the IF statement within excel....
This is some simple code to either "Reset" a user entry workbook or to clear cell values before / after...
Looking for a simple way to keep track of task and dates? This will help you keep track of SLA's...
Dynamically Change Pivot Table Source Data This is a handy bit of code which will save you having to update...
Extract Month from a date There are a couple of ways to extract just the month from a date in...
Developer and VBA Starting Point Firstly you will want to add in the Developer tab to your excel ribbon. File...
SQL Query Into to VBA Language - The Converter This process will enable to you build a SQL query to...
Conditional Formatting - The basics Quick start! By applying conditional formatting to your data, you can quickly identify variances in...