Dynamically Change Pivot Table Source Data This is a handy bit of code which will save you having to update...
guide
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...
Conditional Formatting - The basics Quick start! By applying conditional formatting to your data, you can quickly identify variances in...
Here is place that will be updated with Data processing scripts and tips. IF statement The if statement can be...
This a quick simple way to show how to use buttons to navigate the on the to different worksheets. From...
This code works along the same as the First and Last Month Dates but is for a rolling 12 month....
You can add a Data Validation list based on the value of another cell. For this example, it uses the...
This will check each question entered into the script and if answered will +1 to the starting figure of 0...