This video demonstrates how to write the VBA code that will combine all workbooks in a specified folder into a master workbook. The video also includes the VBA code to sort the imported sheets by sheet name: in this example by month name. The code is shown below the video. Sub MergeWorkbooks() Dim FolderPath As… Read More »Excel VBA to Combine All Workbooks in a Folder Into a Master Workbook
This video details the VBA code needed to hide worksheets that have a coloured sheet tab. It also demonstrates how to hide sheets that have a sheet tab with a specific colour assigned. The VBA code is shown below the video. VBA Code to Hide All Coloured Sheet Tabs Sub HideColouredTabs() Dim ws As Worksheet… Read More »Hide Excel Sheet Based on Sheet Tab Colour – VBA Macro
Thermometer charts are useful if you want to display actual values against target values: for example actual sales against sales target. Follow the tutorial or watch our YouTube tutorial at the bottom of this page. Please see our Excel Dashboard training course if you would like this training delivered at your place of work. Here’s an… Read More »Create a Thermometer Chart in Excel