Here is a full listing of all of my free archived work available for you to download. You can sort the list by clicking on any of the Headers. Search 'Fix' for helpful advice on fixing issues or 'How to' for advice on a range of subjects. Search 'Formula' for formula examples
Please Note: all of this work is licensed under an MIT License (MIT) and Support is NOT given under any circumstances
| Project Name | File | Size | Date |
|---|---|---|---|
| Core Subroutines | mdlCoreSubroutines.bas | 242 KB | 29/06/2016 |
| Password Cracker Excel 2013, 2016 | Password Cracker Excel 2013, 2016.xlsm | 17 KB | 03/10/2019 |
| Password Cracker Excel 1997, 2003 (old versions) | PasswordCracker.xls | 80 KB | 04/05/2015 |
| Animated Waitbar 1 (32bit) | Animated Waitbar.xls | 162 KB | 09/06/2012 |
| Animated Waitbar 2 (32/64bit VBA7) | Animated Waitbar2.xlsm | 76 KB | 09/06/2012 |
| Cool Text Fade Routine (32/64bit) | Cool Text Fade Routine.xlsm | 86170 KB | 24/09/2016 |
| ADODB SQL Example | ADODB SQL Example.xlsm | 98160 KB | 05/03/2015 |
| Display what is being Autofiltered (32/64bit) | AutoFiltered.xlsm | 26 KB | 10/06/2018 |
| GetAsyncKeyState Capture Mouse Clicks or Arrows (32/64bit VBA7) | GetAsyncKeyState Capture Mouse Clicks or Arrows.xlsm | 15 KB | 04/09/2017 |
| Install, Read, Delete Custom Property | Custom Properties.xlsm | 17 KB | 17/05/2018 |
| Delete Duplicates | Delete Duplicates.xlsm | 16 KB | 17/05/2018 |
| Draw Directly on the Screen when Moving Mouse over UserForm | Draw Directly on the Screen when Moving Mouse over UserForm.xlsm | 20 KB | 17/05/2018 |
| Flash Window (32bit & 64bit) | Flash Window.xlsm | 16.8 KB | 07/07/2021 |
| Get UserForm DC | Get UserForm DC.xlsm | 18 KB | 04/11/2017 |
| Picking up list data | Picking up list data.xlsm | 15 KB | 22/01/2018 |
| Rename all Files in a Folder | Rename Files in Folder.xlsm | 18 KB | 14/07/2018 |
| Replace a Format Colour | Replace a Format Colour.xlsm | 29620 KB | 14/07/2018 |
| Build and Select a Range X Columns by Y Rows from a Start Cell | Build and Select a Range X Columns by Y Rows from a Start Cell.xlsm | 15 KB | 02/02/2018 |
| Super AutoFilter and Range AutoFilter | Super AutoFilter.xlsm | 194500 KB | 02/02/2018 |
| Table Example of Fixing Headers as Excel Workbook Headers | Table Example of Fixing Headers as Excel Workbook Headers.xlsx | 9 KB | 22/08/2018 |
| VBA CountIf Replacement | VBA CountIf Replacement.xlsb | 86170 KB | 01/03/2015 |
| Using Defined Names | Using Defined Names.xlsm | 18 KB | 02/04/2014 |
| Tree Node Diagram | Tree Diagram.xlsx | 13 KB | 02/04/2014 |
| Toggle Button Toolbar | Toggle Button Toolbar.xlsm | 63.6 KB | 28/05/2015 |
| Toggle Button Toolbar (with Ribbon pointer restore) | Toggle Button Toolbar (with Ribbon pointer restore).xlsm | 68 KB | 28/05/2015 |
| Toggle Autofilter | Toggle Autofilter.xls | 42 KB | 28/05/2015 |
| Transpose 1 | Transpose.xls | 120 KB | 17/04/2012 |
| Transpose 2 | Transpose2.xls | 133 KB | 09/10/2014 |
| Transpose List Data from Row into Column using Formula | Transpose Lists using Formula.xlsx | 12 KB | 06/07/2017 |
| Blood Pressue Tracker | BloodPressureTracker.xlsx | 71.6 KB | 13/05/2017 |
| Disable And Enable A Button Form Control On A Worksheet | Disable and Enable Form Button.xlsm | 17.6 KB | 29/06/2016 |
| Create Pair Combinations | CreatePairCombos.xlsm | 20 KB | 30/05/2017 |
| Create Treble Combinations | CreateTrebleCombos.xlsm | 19 KB | 09/10/2016 |
| Array as Union of Worksheet Ranges | Array as Union of Worksheet Ranges.xlsm | 36 KB | 08/03/2015 |
| Copy and Paste from the Clipboard using VBA | Copy and Paste from the Clipboard using VBA.xlsm | 15 KB | 09/10/2018 |
| Create Unique List with Counts (1,048,576 Cells) | Count Unique List with Counts.xlsb | 83890 KB | 01/03/2015 |
| Custom Formats | Custom Formats.xlsx | 11 KB | 04/09/2015 |
| XY Scatter Chart with 2x2 and 3x3 Shaded Grid | XY Scatter Chart with 2x2 and 3x3 Shaded Grid.xlsx | 902 KB | 12/03/2016 |
| Truncate | Truncate.xlsx | 10 KB | 12/03/2016 |
| LOGEST, LINEST Calulations | LOGEST, LINEST Calulations.xlsx | 10 KB | 12/03/2016 |
| Excel Reporting Boilerplate | excel boilerplate.xlsm | 218 KB | 14/05/2013 |
| Browse for Folder Subroutines (old and new dialogs) | Browse for Folder.xls | 218 KB | 14/05/2013 |
| Browse for Folder Subroutines (old and new dialogs) | Browse for Folder.xls | 218 KB | 14/05/2013 |
| Kwick Browser featuring Kwicks for jQuery by Jeremy Martin | Browser.xlsm | 106 KB | 16/06/2012 |
| Fast Eval Match | Eval-Match.xlsb | 118350 KB | 09/10/2018 |
| Nice 3 Colour Chart Template | Nice 3 Colour Chart Style Template.xlsx | 19.6 KB | 18/06/2012 |
| Nice Custom Combination Chart Template | Custom-Combination-Chart.xlsx | 15 KB | 26/11/2016 |
| Detect Shift Key | Detect-Shift-Key.xlsm | 16.2 KB | 25/02/2015 |
| Checking and Opening a CSV File | Checking and Opening a CSV File.xlsm | 18.3 KB | 05/03/2015 |
| Cleaning Sales (Outlier Correction and Exponential Smoothing) | Cleaning Sales (Outlier Correction and Exponential Smoothing).xlsx | 18.3 KB | 05/03/2015 |
| Email, CC, BCC From List of Names Macro | Email From a List Macro.xls | 44 KB | 13/02/2013 |
| Email Worksheet from Hyperlink | Email Worksheet from Hyperlink.xlsm | 27 KB | 13/02/2013 |
| Derive Unique List from 2 Worksheets of Data by Formula | Derive Unique List from 2 Worksheets of Data by Formula.xlsx | 231 KB | 13/02/2013 |
| Email Template | Email-Template.xls | 350 KB | 24/06/2011 |
| Pickup Data into Array | Pickup_Mass_Data.xls | 41 KB | 29/04/2012 |
| Blue Excel Button | Blue Excel Button.xlsx | 11 KB | 05/10/2014 |
| Fade a Message Window In and Out | Fade In and Out Mesaage.xlsm | 29 KB | 28/11/2013 |
| Delete Rows by HyperFilter | HyperFilter.xlsm | 29 KB | 22/02/2015 |
| Filterlist Dialog, Searchable, Filter Listbox Control | Filterlist.xlsm | 259 KB | 14/04/2013 |
| Create a Unique List of Key and Items from Multiple Worksheets | Hyperlist.xlsm | 549 KB | 14/04/2013 |
| Conjunction Tool | Conjunction Tool.xlsm | 408 KB | 11/12/2012 |
| Unhide Hidden Named Ranges | Display, List & Unhide Named Ranges.xlsm | 16 KB | 12/11/2012 |
| Facebook Loader | Facebook Loader.xls | 19 KB | 13/10/2012 |
| Facebook Loader 1 | Orange Ajax Loader.xls |
101 KB | 30/10/2012 |
| Facebook Loader 2 | Orange Spinner Loader.xls |
146 KB | 30/10/2012 |
| Facebook Loader 2 | Blue Bubble Loader.xls | 108 KB | 30/10/2012 |
| Handling Hyperlinks | Handling Hyperlinks.xls | 46 KB | 30/10/2012 |
| Tile a Worksheet | Tile Worksheet.xlsx | 17.1 KB | 03/10/2012 |
| Free Background Tiles | Background Tiles.zip | 449 KB | 03/10/2012 |
| Find Header and Iterate Range Examples | Find Header and Iterate Range Examples.xlsm | 23.5 KB | 13/03/2015 |
| Minimal Excel Workbooks 1 | Clean Single Sheet Minimalist Excel Workbook.xlsm | 15.5 KB | 03/10/2012 |
| Minimal Excel Workbooks 2 | Minimalist Survey Workbook with Single Ribbon Tab, Group & Button.xlsm | 17.9 KB | 03/10/2012 |
| Minimal Excel Workbooks 3 | Clean Reading View.xlsm | 23.7 KB | 03/10/2012 |
| Colour Picker 1 | Colour Picker.xlsm | 22.8 KB | 04/01/2014 |
| Colour Picker 2 | Color Picker 2012.xls | 19 KB | 04/01/2014 |
| Colour Picker 3 | Colour Picker 2012.xls | 58 KB | 15/10/2012 |
| Colour Picker 4 | Colour Picker 2012.xlsm | 20.8 KB | 15/10/2012 |
| Hide Pivot Table Columns | Hide Columns in Pivot Table Data Range.xlsm | 29.6 KB | 04/01/2014 |
| Multiple Slicers | Using Multiple Slicers with Multiple Pivot Tables.xlsm | 31.2 KB | 12/03/2017 |
| Adaptive XY Rollover Technique | XYRollover.xlsm | 15.7 KB | 10/12/2013 |
| Rollovers 1 | Rollover Example.xlsm | 32.9 KB | 10/12/2013 |
| Rollovers 2 | Standard Report Schema (Rollover-enabled).xlsm | 22.2 KB | 10/12/2013 |
| Rollovers 3 | Business Report Schema (Rollover-enabled).xlsm | 22.2 KB | 10/12/2013 |
| Rollovers 3 | Disable Cursor Movement in Menu.xlsm | 21.7 KB | 10/12/2013 |
| Juiicy Rollovers | Juiicy-Themes.zip | 201 KB | 30/11/2013 |
| Read File Byte by Byte and Debug Print the Contents | Read-File-Byte-by-Byte.xlsm | 16 KB | 10/04/2018 |
| Select and Paste Multiple Range Areas | Select & Paste Multiple Range Areas.xls | 52 KB | 01/05/2013 |
| Data Validation Using RegEx | Regular Expressions.xlsm | 18 KB | 16/11/2013 |
| RegEx Patterns | RegEx-Patterns.txt | 4 KB | 16/11/2013 |
| Protecting Cell Integrity including Paste | Protecting Cell Data Integrity and Paste.xlsm | 26.2 KB | 30/05/2019 |
| Protecting Cell Integrity | Protecting Cell Data Integrity.xlsm | 19.7 KB | 10/10/2013 |
| Jagged Array Data En Masse | Pick up Data En Masse.xlsm | 18.9 KB | 18/10/2013 |
| Typography | Typography.zip | 196 KB | 04/10/2013 |
| Metro Rollover Menu | Metro Menu.zip | 36.2 KB | 01/10/2013 |
| Create Worksheets By a List | Create Worksheets by List Macro.xlsm | 110 KB | 24/10/2014 |
| Sort Jagged Worksheet Array Data | Jagged Sort.xlsm | 3430 KB | 24/10/2014 |
| Transpose Horizontal Data | Transpose Horizontal Data.xls | 132 KB | 09/10/2014 |
| Transpose Horizontal Data (Excel 2010+) | Transpose Horizontal Data.xlsm | 68.9 KB | 21/03/2019 |
| Transpose Horizontal Data Args | Transpose Horizontal Data with Function Args.xls | 120 KB | 09/10/2014 |
| Five Year Rolling Calendar | Rolling ISO 5 Year Calendar for Week Lookups.xlsx | 33.2 KB | 06/10/2014 |
| Calendar 1 | Calendar.xls | 71 KB | 04/10/2014 |
| Calendar 2 | Calendar.xlsm | 38 KB | 04/10/2014 |
| Calendar 3 | Calendar-v3.xlsm | 38 KB | 04/10/2014 |
| Calendar 4 | Calendar-v4.xlsm | 39.7 KB | 16/12/2014 |
| Hamilton Largest Remainder Method | Hamiltons Largest Remainder Method using the Hare & Droop Quota.xlsx | 15 KB | 01/09/2014 |
| Lotto Hotpick Analyser | lotto hotpick analyser.xlsm | 3140 KB | 11/05/2014 |
| Resize Range and Formula on Paste 1 | Copy & Paste to Resize Range and Automatically Adjust Formulas to Match.xlsm | 18.6 KB | 06/02/2014 |
| Resize Range and Formula on Paste 2 | Copy & Paste to Resize Range and Automatically Adjust Formulas to Match (as values).xlsm | 18.6 KB | 06/02/2014 |
| Full Screen Fade Overlay | Fade Overlay.xlsm | 54.2 KB | 01/01/2014 |
| Generate Text and Number Combinations | Generate Combinations using Formula.xlsx | 23.5 KB | 01/10/2015 |
| Read and Import CSV Files 1 | Read & Import CSV Files.xlsm | 23.1 KB | 09/09/2015 |
| Read and Import CSV Files 2 | Test Data.csv | 14.2 KB | 09/09/2015 |
| Prevent Multiple Pivot Table Slicer Selections | Prevent Multiple Pivot Table Slicer Selections & Capture Mouse Clicks.xlsm | 23.9 KB | 20/05/2015 |
| Hide or Minimise the Ribbon | Hide Ribbon.xlsm | 10.8 KB | 16/05/2015 |
| Hide or Minimise the Ribbon Persist | Hide Ribbon & Persist FullScreen When Minimized.xlsm | 12.5 KB | 16/05/2015 |
| Hide or Minimise the Ribbon SendKeys | Hide Ribbon SendKeys.xlsm | 10.8 KB | 16/05/2015 |
| Radio Button | Radiobutton.xlsm | 18.2 KB | 27/02/2015 |
| Check Box | Checkbox.xlsm | 16.2 KB | 25/02/2015 |
| Tick Box | Tickbox.xlsm | 15.5 KB | 25/02/2015 |
| Control Pivot Tables With Slicers 1 | Using Multiple Slicers with Multiple Pivot Tables.xlsm | 31.2 KB | 13/05/2015 |
| Control Pivot Tables With Slicers 2 | Using a Slicer to Control Multiple Pivot Tables.xlsm | 33.2 KB | 13/05/2015 |
| Control Pivot Tables With Slicers 3 | Using one Slicer to Control Single Pivot Tables on Multiple Worksheets.xlsm | 35.4 KB | 13/05/2015 |
| Control Pivot Tables With Slicers 4 | Dynamic Update of Pivot Table Source.xlsm | 19.4 KB | 13/05/2015 |
| Control Pivot Tables With Slicers 5 | Using individual Slicers to Control Multiple Pivot Tables on Multiple Worksheets.xlsm | 47.7 KB | 13/05/2015 |
| Control Pivot Tables With Slicers 6 | Multiple PivotTables with Individual Slicers on 2 Worksheets.xlsm | 36.6 KB | 13/05/2015 |
| Control Pivot Tables With Slicers 7 | Using Multiple Slicers to Control Pivot Tables on Multiple Worksheets.xlsm | 39.1 KB | 13/05/2015 |
| Powerpoint Traffic Light Conditional Format | Conditional Format PowerPoint.pptm - PowerPoint | 48.5 KB | 31/08/2016 |
| Resize Alternative For ReDim Preserve | Resize.xlsm | 66.4 KB | 30/08/2016 |
| Transpose Dictionary Alternative For Application Transpose | Transpose Dictionary.xlsm | 19.7 KB | 25/08/2016 |
| UI Elements, Rollover Buttons and Tree List | UI Elements.xlsm | 45.6 KB | 16/04/2016 |
| Rhino Dashboard Template | rhino.xlsx | 10 KB | 01/01/2017 |
| Rhino Dashboard Zip | Rhino.zip | 204 KB | 01/01/2017 |
| Hide Taskbar Routines | Hide Taskbar Routines.xls | 112 KB | 09/03/2012 |
| Get Range Using Application InputBox | Application-InputBox.xlsm | 15.4 KB | 10/10/2012 |
| Force Cell And Case Formatting | Force Case.xls | 34 KB | 01/10/2012 |
| Generate Random Data 1 | Generate Random Text Data.xlsm | 18.9 KB | 07/11/2012 |
| Generate Random Data 2 | Generate Random Numeric Data.xlsm | 22.3 KB | 07/11/2012 |
| Generate Random Data 3 | Generate Random Numeric Row Data Subroutine.xlsm | 17.4 KB | 07/11/2012 |
| Get Range Data By Header | Get-Range-Data.xls | 126 KB | 10/10/2012 |
| Get Column Letter From Column Number | Get-Column-Letter.xlsm | 16.3 KB | 10/10/2012 |
| Get Column Number From Column Letter | Get-Column-Number.xlsm | 15.6 KB | 10/10/2012 |
| Build And Select Dynamic Range | Build-Dynamic-Range.xlsm | 16.4 KB | 10/10/2012 |
| Get Last Row | Get-Last-Row.xlsm | 18.1 KB | 31/10/2012 |
| Google Charts Google-O-Meter 2.1.0.0 | GoogleOMeter.xlsm | 33 KB | 16/04/2022 |
| Google Charts Google-O-Meter | Google-O-Meter.xls | 89 KB | 16/10/2012 |
| Google Charts Google-O-Meter Deprecated | Google-O-Meter Chart Image Generator.xls - deprecated | 94 KB | 16/10/2012 |
| Message Light Box MsgLightbox | MsgLightbox.xls | 73.5 KB | 16/10/2012 |
| Trial Dialog | Trial Dialog.xls | 49.5 KB | 15/10/2012 |
| Worksheet Browser 1 | Worksheet-Browser.xlsm | 20.3 KB | 10/10/2012 |
| Worksheet Browser AddIn | Worksheet Browser.xlam | 55.5 KB | 10/10/2012 |
| Worksheet Browser Zip | Worksheet Browser.zip | 106 KB | 10/10/2012 |
| Progressbar HTML Sheet Non Modal 1 | Progressbar with HTML Sheet (Non Modal).xls | 73.5 KB | 13/10/2012 |
| Progressbar HTML Sheet Non Modal 2 | Non-Modal Progressbar with HTML Sheet Markup.xls | 71.5 KB | 13/10/2012 |
| Progressbar Markup Non Modal 1 | Progressbar with Self-contained HTML Markup (Non Modal).xls | 68.5 KB | 13/10/2012 |
| Progressbar Markup Non Modal 2 | Non-Modal Progressbar Self-contained Markup.xls | 66.5 KB | 13/10/2012 |
| Progressbar Modal | Modal Progressbar with HTML Sheet Markup.xls | 71 KB | 13/10/2012 |
| Progressbar UserForm Zip | Progressbar (Non Modal) FRM.zip | 4.44 KB | 13/10/2012 |
| Math Functions Sigma And Huge Strings | Math Functions.xls, All Math Functions and Sigma | 82 KB | 22/05/2013 |
| Math Functions Multi-purpose and Multiplication | Math Function.xls, Multi-purpose and Multiplication | 79 KB | 22/05/2013 |
| Sigma Function | Sigma Function.xls | 36 KB | 22/05/2013 |
| Indexing Worksheet Data Using Dictionary | Indexing a Worksheet.xls | 4710 KB | 26/10/2012 |
| Indexing Worksheet Data Using Dictionary Small File | Indexing a Worksheet (Blank Data).xls, smaller file to download | 48 KB | 26/10/2012 |
| List And Move Desktop Icons | Desktop-Icons.xlsm | 35 KB | 26/03/2015 |
| Create Shortcut using VBA | Create Shortcut.xlsm | 16 KB | 21/10/2012 |
| Prime Number Functions | Prime-Functions.xls | 144 KB | 27/10/2012 |
| Prime Number Checker | Prime-Number-Checker.xls | 41.5 KB | 27/10/2012 |
| Purge Workbook Data And Formula En Masse | Purge.xlsb | 2250 KB | 12/09/2014 |
| Sorting Algorithms, Selection Sort | Selection Sort.xlsm | 21.5 KB | 20/05/2013 |
| Sorting Algorithms, Bubble Sort | Bubble Sort.xlsm | 21.6 KB | 20/05/2013 |
| Sorting Algorithms, Insertion Sort | Insertion Sort.xlsm | 21.4 KB | 20/05/2013 |
| Sorting Algorithms, Counting Sort | Counting Sort.xlsm | 19.3 KB | 20/05/2013 |
| Sorting Algorithms, Heap Sort | Heap Sort.xlsm | 21 KB | 20/05/2013 |
| Sorting Algorithms, Comb Sort | Comb Sort.xlsm | 21.2 KB | 20/05/2013 |
| Social Webpage Encoders, Facebook | Facebook Social URL Link Encoder.xlsm | 25.8 KB | 20/10/2012 |
| Social Webpage Encoders, Twitter | Twitter Social URL Link Encoder.xlsm | 25.4 KB | 20/10/2012 |
| Social Webpage Encoders, Linked In | LinkedIn Social URL Link Encoder.xlsm | 26 KB | 20/10/2012 |
| Email Template Outlook | email-template (Outlook).zip | 2210 KB | 20/10/2012 |
| Kiosk 4.1 Full Screen Excel | Kiosk4.1.xlsm | 149 KB | 20/10/2012 |
| Kiosk 4.1 AddIn Full Screen Excel | Kiosk4.1.xlam | 288 KB | 20/10/2012 |
| Kiosk 4.1 Full Screen Excel Zip | Kiosk4.1.zip | 570 KB | 20/10/2012 |
| Full Screen Excel | Open Full Screen & Hide Everything Example.xlsm | 16 KB | 20/10/2012 |
| Full Screen Excel Slideshow | Slideshow Example.xlsm | 3730 KB | 20/10/2012 |
| Kiosk Full Screen Borderless Excel | Kiosk.xlsm | 49.1 KB | 14/06/2014 |
| Kiosk Full Screen Borderless Excel Automation | Automation Example for Kiosk.xlsm | 15.7 KB | 14/06/2014 |
| Kiosk v6 Full Screen Excel | Kiosk v6.xlsm | 77.2 KB | 16/10/2012 |
| Kiosk v6 Dev Full Screen Excel | Kiosk v6 Dev.xls | 119 KB | 16/10/2012 |
| Kiosk v6 Dev AddIn Full Screen Excel | Kiosk v6.xlam | 115 KB | 16/10/2012 |
| Kiosk v6 Dev Zip | Kiosk v6.zip | 255 KB | 16/10/2012 |
| Kiosk v6 Dev Full Screen Excel All Versions | Kiosk.xls - all versions 9-14, download and press F4 | 121 KB | 16/10/2012 |
| Ribbon Extensibility XLRibbonX | XLRibbonX.xlsm | 91.1 KB | 25/10/2012 |
| Ribbon Extensibility AddIn XLRibbonX | XLRibbonX.xlam | 149 KB | 25/10/2012 |
| Colour Banding | Colour-Banding.xls | 41 KB | 21/05/2013 |
| Colour Banding, Rollover | Colour Banding with Hyperlink Rollover.xlsm | 25.4 KB | 21/05/2013 |
| Colour Banding, Formula | Colour-Banding-Formula.txt | 2 KB | 21/05/2013 |
| Colour Pallets Report Template | Reporting Template Pallet.xls | 25.5 KB | 03/10/2012 |
| Colour Pallets Office 2013 | Office 2013 Pallet.xls | 23.5 KB | 03/10/2012 |
| Report Template | Reporting Template.xls | 120 KB | 13/10/2012 |
| Generate CVCS (Combinations) Using Formula | Generate CVC's using Formula.xlsx | 23.3 KB | 27/09/2015 |
| Generate Combinations Using Formula with Descriptions | Generate Combinations using Formula with Descriptions.xlsx | 16 KB | 17/04/2022 |
| CPG Splitter Tool | CPG Splitter.xlsm | 195 KB | 30/08/2014 |
| CVC Generator | CVC Generator.xlsm | 79.4 KB | 23/11/2013 |
| Hamilton Largest Remainder Method Tool | Phase & Split.xlsx | 132 KB | 21/09/2015 |
| Hamilton Product Split Tool | Hamilton Promotional Volume Product Split Tool.xlsx | 109 KB | 01/11/2014 |
| Hamilton Phasing Tool | Hamilton Promotional Volume Phasing Tool v2.xlsx | 21.5 KB | 01/11/2014 |
| Hamilton Promotional Volume Splitter Tool 1 | Promotional Volume Splitter.xlsb | 252 KB | 30/08/2014 |
| Hamilton Promotional Volume Splitter Tool 2 | Promotional Volume Splitter (old version).xlsb | 124 KB | 30/08/2014 |
| Hamilton Hare and Droop Quota | Hamiltons Largest Remainder Method using the Hare and Droop Quota.xlsx | 15 KB | 30/08/2014 |
| Scrolling Category Chart | Category Charts.xlsb | 477 KB | 21/08/2014 |
| Promotional Volume CSV File Creator | Promo File.xlsm | 300 KB | 19/11/2013 |
| Booking System | Booking System with Counts.xlsm | 159 KB | 17/04/2015 |
| Booking System v3 | Booking System v3.xls | 325 KB | 17/04/2015 |
| Booking System v4 | Booking System v4.xlsb | 99.7 KB | 17/04/2015 |
| Booking System v5 | Booking System v5.xlsm | 186 KB | 17/04/2015 |
| Booking System v5.1 Media Demo | Media Booking System Demo (version 5.1).xlsm | 186 KB | 17/04/2015 |
| Booking System v6 | Booking System v6 (unfinished).xlsm | 67 KB | 17/04/2015 |
| Booking System v7 | Booking System v7.xlsm | 159 KB | 17/04/2015 |
| SendMail Template v1.3 | SendMail v1.3.xlsm | 123KB | 02/05/2015 |
| SendMail v2 | SendMail.xlsm - version 2 | 129 KB | 02/05/2015 |
| SendMail Widget Report | Widget Report.xlsm - mail a report | 94.5 KB | 02/05/2015 |
| SendMail Widget Report as PDF | Widget Report as PDF.xlsm - mail as PDF | 94.6 KB | 02/05/2015 |
| Build a Ribbon Toolbar | Ribbon Toolbar.xlsm | 35.6 KB | 02/05/2015 |
| Embedding Fonts | Embedding Multiple Fonts.xlsb | 153 KB | 21/04/2015 |
| Rollover Toolbar | Rollover Toolbar.xlsb | 304 KB | 14/04/2015 |
| Rollover Toolbar using Font Awesome | Rollover Toolbar Sheet Navigator using Font Awesome.xlsb | 629 KB | 14/04/2015 |
| Rollover Toolbar Extended Menu | Menu.xlsm - extended menu by Emanuelle Lacroix | 421 KB | 14/04/2015 |
| Rollover Toolbar Extended Full Screen Menu | Menu (fullscreen).xlsm - extended menu by Emanuelle Lacroix | 420 KB | 14/04/2015 |
| Pivot Slicer Button Toolbar 1 | Pivot Toolbar.xlsb | 307 KB | 08/03/2015 |
| Pivot Slicer Button Toolbar 2 | Pivot Toolbar.xlsm | 39.6 KB | 08/03/2015 |
| Pivot Slicer Button Toolbar with OLE Embedded Font | Pivot Toolbar (OLE Embedded Font).xlsb | 74.9 KB | 08/03/2015 |
| Spinner PixelBuddha Preloaders | Spinner.xlsm | 1030 KB | 10/04/2014 |
| Spinner PixelBuddha Preloaders UserForm | Spinner UserForm.zip | 284 KB | 10/04/2014 |
| Spinner PixelBuddha Preloaders Single Spinner | Single Spinner.xlsm | 431 KB | 10/04/2014 |
| Spinner Fade In and Out HTML | Spinner fade in and out.html | 34.8 KB | 10/04/2014 |
| Spinner Fade In and Out Source HTML | Spinner fade in and out (source).html | 34.7 KB | 10/04/2014 |
| Nanoscopic VBA Progressbar 1 | Progressbar.xlsm | 102 KB | 28/03/2014 |
| Nanoscopic VBA Progressbar 2 | Progressbar.xls | 177 KB | 28/03/2014 |
| Nanoscopic VBA Progressbar UserForm | Progressbar UserForm.zip | 15.3 KB | 28/03/2014 |
| Filterlist Fast Flexible Searchable List Control | Filterlist.zip | 1080 KB | 15/04/2013 |
| Filterlist Fast Flexible Searchable List Control Bolierplate | filterlist boilerplate.xlsm | 1130 KB | 15/04/2013 |
| Filterlist Fast Flexible Searchable List Control Autofilter | filterlist autofilter boilerplate.xlsm - an example of using Filterlist to Filter data | 287 KB | 15/04/2013 |
| Delicious Rollover Drop Down Menu | Delicious.xlsm | 50.1 KB | 16/10/2013 |
| Delicious typography | delicious.xlsx | 14 KB | 16/10/2013 |
| Delicious Rollover Drop Down Menu Zip | Delicious.zip | 100 KB | 16/10/2013 |
| Delicious Rollover Drop Down Menu Blue Theme | drop-down menu boilerplate (blue).xlsm | 33 KB | 16/10/2013 |
| Delicious Rollover Drop Down Menu Examples with Multiple Menus & Links to Worksheets | drop-down-menu-boilerplate-blue-multiple-menus.xlsm | 47.3 KB | 14/10/2018 |
| Delicious Rollover Drop Down Menu for Older Excel Versions | Delicious-2007-version.xlsm | 50.9 KB | 16/10/2013 |
| Preloader 64bit Transition Using Spin JS Library By Felix Gnass | Preloader64bit.xlsm | 738 KB | 05/08/2013 |
| Preloader Transition Using Spin JS Library By Felix Gnass | Preloader.xlsm | 332 KB | 05/08/2013 |
| Preloader Transition Using Spin JS Library By Felix Gnass Zip | Preloader.zip | 330 KB | 05/08/2013 |
| Preloader Transition Using Spin JS Library By Felix Gnass Workbook | VBA Projects - Preloader.xls - Blank Preloader Workbook | 139 KB | 05/08/2013 |
| BI RIBBONX Format Report Data AddIn v1.1 | BI__RibbonX.xlsm | 56.9 KB | 28/12/2016 |
| BI RIBBONX Format Report Data AddIn v1.1 | BI__RibbonX.xlam | 52.9 KB | 28/12/2016 |
| BI RIBBONX Format Report Data AddIn v1 | BI__RibbonX (1).xlsm | 56.2 KB | 28/12/2016 |
| BI RIBBONX Format Report Data AddIn v1 | BI__RibbonX (1).xlam | 41.6 KB | 28/12/2016 |
| Little Chart Widgets | LittleChartWidgets.xlsx | 74.7 KB | 28/05/2017 |
| Dynamic Chart | DynamicChart.xlsx | 35.4 KB | 28/05/2017 |
| Event Planner | Demand Event Planner.xlsm | 55 KB | 12/02/2018 |
| Row Formatting Macro | Row Formatting Example.xlsm | 24 KB | 12/02/2018 |
| Multiplex v6, Fast Array Manipulation | Multiplex.xlsm | 203 KB | 08/10/2018 |
| Multiplex v6 Class, View the Class File as Text | Multiplex.clsm | 73 KB | 08/10/2018 |
| Multiplex v8, Fast Array Manipulation | Multiplex8.xlsm | 194 KB | 30/06/2021 |
| R1C1 Locking Formula in VBA | R1C1 Lock Formula.xlsm | 16 KB | 08/10/2018 |
| Formula to Repeat Column Items X Times | Repeat Value X Times.xlsx | 10 KB | 08/10/2018 |
| Formula to Create a Unique List of Text Items (Case Insensitive) | Unique List Formula.xlsx | 10 KB | 08/10/2018 |
| Formula to SUM Columns by Column Criteria and Row Criteria | SUM Columns by Column Criteria & Row Criteria.xlsx | 10 KB | 08/10/2018 |
| Formula to SUMIF and to Exclude Criteria | SUMIFS to Exclude Criteria.xlsx | 9 KB | 08/10/2018 |
| Formula to do a Backwards VLOOKUP using CHOOSE | Backwards VLOOKUP using CHOOSE.xlsx | 10 KB | 08/10/2018 |
| Formula to SUM Values in a Column until the Next Empty Cell | SUM Values in Columns until a Blank Cell.xlsx | 14 KB | 08/10/2018 |
| Formula to do MOD Patterns, SUM Numbers Every nth Row | SUM Numbers Every nth Row.xlsx | 9 KB | 08/10/2018 |
| Formula to Derive the Last X Weeks Average from Weekly Columns of values | Average of X Weeks from Weekly Columns.xlsx | 14 KB | 01/05/2017 |
| Formula to Identify Duplicates in a List | Identify Duplicates in a List using Formula.xlsx | 10 KB | 01/05/2017 |
| Formula to Reverse or Sort a Column of Data that Cannot usually be Sorted | How-to-Reverse-or-Sort-a-Column-of-Data-that-Cannot-usually-be-Sorted.txt | 1 KB | 08/10/2018 |
| Formula to Extract Product Code and Description | Extract Product Code and Description.xlsx | 10 KB | 08/10/2018 |
| Formula for Boolean Replacement for IF | Replacement for IF.xlsx | 9.39 KB | 08/10/2018 |
| Formula for Boolean Switch | Boolean Switch.xlsx | 12.1 KB | 08/10/2018 |
| Formula Find First Sold In | First Sold In Example.xlsx | 994 KB | 08/10/2018 |
| Formula Find Last Sold In | Last Sold In Example.xlsx | 773 KB | 08/10/2018 |
| Formula Transpose Block of N Rows to Columns | Transpose N Rows to Columns.xlsx | 10 KB | 08/10/2018 |
| Formula Using SUMPRODUCT with Filtered or Hidden Rows | Using SUMPRODUCT with Hidden or Filtered Rows.xlsx | 11 KB | 08/10/2018 |
| Formula to Setup and Format a Rolling ISO Week Number | How to Setup and Format a Rolling ISO Week Number.xlsx | 11 KB | 08/10/2018 |
| Formula to Conditional Format Highlight Dates in Current Year | Date Format.xlsx | 12 KB | 08/10/2018 |
| Formula to SUM or Average the Top 10 or Top X Numbers in a Range | AVG Top 10 Numbers.xlsx | 11 KB | 27/03/2018 |
| Formula for Multiple 3 Column Lookup to Return Single or Concatenated 2 Column Values | Multiple Lookups Using Array Formula.xlsx | 10 KB | 08/10/2018 |
| Formula for Dynamic Named Range or Defined Name to Capture a Range using Offset | Dynamic Named Ranges.xlsx | 12 KB | 08/10/2018 |
| Formula for Top Ten Ranking List | Top Ten List.xlsx | 16 KB | 08/10/2018 |
| Array Formula for SMALL, LARGE, AVG, AND and OR Operators | First N Numbers & AND OR Operators.xlsx | 10 KB | 03/10/2017 |
| First Sold In Formula | First Sold In Formula.xlsx | 10 KB | 27/10/2017 |
| Fix Open the VBA Editor in a Code Module of your Choice | Open-the-VBA-Editor-in-a-Code-Module-of-your-Choice.txt | 2 KB | 08/10/2018 |
| Fix Code execution has been halted Issue | Code-execution-has-been-halted.txt | 1 KB | 08/10/2018 |
| Fix Excel Opens Two Files When Opening A Workbook | Excel-Opens-Two-Files-when-Opening-a-Workbook.txt | 1 KB | 08/10/2018 |
| Fix Hiding Public Subroutines From The Macro Dialog Or ALT And F8 Keypress | Hide-Subroutines.txt | 1 KB | 08/10/2018 |
| Fix Cancel Or Reset Text To Column Settings | How-to-Cancel-or-Reset-Text-To-Column-Settings.txt | 1 KB | 08/10/2018 |
| How to Enable Macros & Trust access for the VBA Project Object Model (VBOM) | Enable-Macros-and-Trust-access-for-the-VBA-Project-Object-Model.txt | 1 KB | 08/10/2018 |
| How to Install and Uninstall AddIns | Install-and-Uninstall-AddIns.txt | 2 KB | 08/10/2018 |
| How to Protect the Data Integrity of Cells | Protect-the-Data-Integrity-of-Cells.txt | 2 KB | 08/10/2018 |
| How to Quickly Multiply lots of Cells by a Number | Multiple-lots-of-Cells-by-a-Number.txt | 1 KB | 08/10/2018 |
| How to Quickly Enter the same Value or Character to lots of Cells | Quickly-Enter-the-same-Value-or-Character-to-lots-of-Cells.txt | 1 KB | 08/10/2018 |
| How to Prevent or Remove the word (Blank) in Pivot Tables | How-to-Prevent-or-Remove-the-word-(Blank)-in-Pivot-Tables.txt | 1 KB | 08/10/2018 |
| Widget Rollover Buttons | code-widgets-buttons.xlsm | 18.7 KB | 17/12/2013 |
| Chocolate & Mint Rollover Buttons | Chocolate-Mint-Rollover-Buttons.xlsm | 15.2 KB | 17/12/2013 |
| Highlight Autofiltered Header Fields in Yellow when Filtered | Highlight-Autofilter-Headers-when-Filtered.xls | 37 KB | 18/02/2009 |
| Dynamically Add Code Subroutine to a Sheet Code Module | Dynamically-Add-Code-to-Sheet-Module.xls | 20.5 KB | 18/02/2009 |
| Dynamically Export a Code Module with Code | Export-Code-Module.xls | 20.5 KB | 28/04/2008 |
| Get the Time Taken to do a Task | Get-Time-Taken.xls | 37 KB | 24/06/2008 |
| BEx Scheduler | Sheduler.xlsm | 45.8 KB | 20/05/2015 |
| Booking System | Booking System.xlsm | 186 KB | 04/02/2015 |
| Multiple Lookups using Array Formula (Lookup 3 Values) | Multiple Lookups Using Array Formula (3 Columns).xlsx | 10.2 KB | 12/11/2015 |
| On Workbook Open Subroutines (which is Fired first) | On Open Example.xlsm | 12.9 KB | 20/05/2015 |
| email-template (Linker) Install & Uninstall as Template (.xls) | email-template (Linker) Install & Uninstall as Template.xls | 78.5 KB | 26/09/2012 |
| email-template (Linker) Install & Uninstall as Template (.xlsm) | email-template (Linker) Install & Uninstall as Template.xlsm | 40.4 KB | 26/09/2012 |
| email-template (Linker) (.xls) | email-template (Linker).xls | 70.5 KB | 26/09/2012 |
| email-template (Linker) (.xlsm) | email-template (Linker).xlsm | 37 KB | 26/09/2012 |
| email-template (Outlook) Install & Uninstall as Template (.xls) | email-template (Outlook) Install & Uninstall as Template.xls | 182 KB | 22/10/2012 |
| email-template (Outlook) Install & Uninstall as Template (.xlsm) | email-template (Outlook) Install & Uninstall as Template.xlsm | 94.2 KB | 23/10/2012 |
| email-template (Outlook) (.xls) | email-template (Outlook).xls | 163 KB | 22/10/2012 |
| email-template (Outlook) (.xlsm) | email-template (Outlook).xlsm | 93 KB | 23/10/2012 |
| Kiosk 4.1 AddIn Zip | Kiosk 4.1 AddIn.zip | 568 KB | 20/10/2012 |
| Open Full Screen & Hide Taskbar Example (requires Kiosk 4.1 AddIn) | Open Full Screen & Hide Taskbar Example.xlsm | 19.6 KB | 13/11/2012 |
| Sending a Widget Report Example (.xls) | Sending a Widget Report Example.xls | 194 KB | 23/10/2012 |
| Sending a Widget Report Example (.xlsm) | Sending a Widget Report Example.xlsm | 103 KB | 23/10/2012 |
| Sort a Row of Data across Many Columns using my Numeric Sort | NumericRowSort.xlsm | 72.4 KB | 18/11/2012 |
| Force Cell Formatting for Font & Font Colour | Force Cell Formatting.xls | 46.5 KB | 02/11/2012 |
| Facebook Loader with HTML Sheet (Non-Modal) | Facebook-Loader-with-HTML-Sheet-(Non-Modal).xls | 72.5 KB | 30/08/2012 |
| Facebook Loader with Self contained HTML Markup (Non-Modal) | Facebook-Loader-with-Self-contained-HTML-Markup-(Non-Modal).xls | 68 KB | 30/08/2012 |
| Facebook Style (.htm) | Facebook Style.htm | 14.6 KB | 21/09/2012 |
| Facebook Base 64 Loader (.htm) | Facebook-Loader.htm | 5.08 KB | 21/09/2012 |
| Ajax Orange Loader (.htm) | Ajax Orange Loader.htm | 6.42 KB | 12/02/2012 |
| Blue Bubble Loader (.htm) | Blue Bubble Loader.htm | 7.87 KB | 21/09/2012 |
| Metro Menu Boilerplate | metro menu boilerplate.xlsm | 32 KB | 14/05/2013 |
| Minimal Metro Menu Boilerplate | minimal metro menu boilerplate.xlsm | 32.8 KB | 21/05/2013 |
| Autofilter, Freeze Panes & Report View Reset | Autofilter, Freeze Panes & Report View Reset.xlsm | 89.1 KB | 20/11/2013 |
| Minimize & Maximize Ribbon height | Minimize & Maximize Ribbon.xlsm | 12.7 KB | 16/05/2015 |
| Another Rollover Technique by Mark | Rollover.xlsm | 15.3 KB | 08/12/2013 |
| BI RibbonX (.xlsm) | BI__RibbonX.xlsm | 56.2 KB | 08/03/2014 |
| BI RibbonX AddIn (.xlam) | BI__RibbonX.xlam | 41.6 KB | 08/03/2014 |
| Juiicy (.xlsx) | juiicy.xlsx | 13.9 KB | 16/10/2013 |
| Juiicy (.xlsm) | Juiicy.xlsm | 21.19 KB | 26/12/2013 |
| Juiicy Zip (lots of Juiicy Stuff) | Juiicy.zip | 1389 KB | 26/12/2013 |
| Nanoscopic Progressbar | Progressbar.xlsm | 102 KB | 28/03/2014 |
| Nanoscopic Progressbar (.xls) | Progressbar.xls | 278 KB | 28/03/2014 |
| Nanoscopic Progressbar Userform | Progressbar UserForm.zip | 15.3 KB | 28/03/2014 |
| Modal Progressbar with HTML Sheet Markup | Modal Progressbar with HTML Sheet Markup.xls | 86.5 KB | 28/03/2014 |
| Partial String Matching with VLOOKUP and INDEX, MATCH | Partial String Matching.xlsx | 86.5 KB | 28/03/2014 |
| Badass! Email Template for Excel | Badass_v1.xlsx | 35 KB | 10/01/2020 |
| Snatch Data Pulling for Excel | Snatch_v1.zip | 51 KB | 10/01/2020 |
| Reorder Lists of Data including Dates for Blanks and Zeros in Contiguous Rows | Testing Reordering.xlsx | 14.5 KB | 11/01/2020 |
| Leaf - Tree Functions to SUM the traversed Leaves of a Fictional Tree | Leaf Functions.xlsm | 17.8 KB | 14/01/2020 |
| Derive Lists of People who own Cars in Columns from a Table | Derive Lists of People who Own Cars from a Table.xlsx | 11.5 KB | 18/01/2020 |
| A very simple Forecast Template in nice Dark Black and Orange Colours to Modify for a Project or for Daily use | Simple Dark Forecast Template.xlsx | 21 KB | 18/01/2020 |
| A lovely Candy Cane Background used together with a Pivot Table with a Highlighter Marker | Candy Cane for Pivot Tables - Design Layout.xlsm | 145 KB | 18/01/2020 |
| A Candy Cane Stripe PNG to use as an Excel Background | Candy-Cane-Stripe.png | 357 Bytes | 18/01/2020 |
| Monthly Sales Analysis YoY with Up/Down Arrows and Formula for Percentage Increase/Decrease and Custom Cell Format | Monthly Sales Analysis YoY.xlsx | 30.9 KB | 18/01/2020 |
| Weekly Sales Analysis YoY with Up/Down Arrows and Formula for Percentage Increase/Decrease and Custom Cell Format | Weekly Sales Analysis YoY.xlsx | 35.1 KB | 18/01/2020 |
| A Simple Static Model for Arithmetic Coding in Excel | Arithmetic Coding Simple Static Model for Excel.xlsm | 18.5 KB | 18/01/2020 |
| Alert Message for Excel on a Lightbox | Alerts.xlsm | 49.4 KB | 18/01/2020 |
| Use Hyperlink as a Toggle to Expand & Collapse or Sort a Pivot Table Field Detail | Promotion Pivot Table Toggle and Sort Example.xlsm | 337 KB | 18/01/2020 |
| Highlight any Row in any Worksheet using a ThisWorkbook Event Handler | Select Code.xls | 40 KB | 15/11/2012 |
| Black and White Slicer Buttons to use with Pivot Tables | Black and White Slicer Buttons.xlsm | 29.4 KB | 18/01/2020 |
| Copy a Resized Range from one Worksheet to Another | Copying Ranges.xlsm | 19.1 KB | 18/01/2020 |
| Creative Sales and Forecast Category Analysis Chart Full Size 1 | Category Analysis.xlsx | 138 KB | 19/01/2020 |
| Creative Sales and Forecast Category Analysis Chart Full Size 2 | Category Analysis (alt. style 1).xlsx | 88.4 KB | 19/01/2020 |
| Creative Sales and Forecast Category Analysis Chart Full Size 3 | Category Analysis (alt. style 2).xlsx | 94.1 KB | 19/01/2020 |
| Creative Sales and Forecast Category Analysis Chart Full Size 4 | Category Analysis (alt. style 3).xlsx | 87.4 KB | 19/01/2020 |
| Make a List form 3 Columns or 3 Lists | Make List from 3 Columns.xlsx | 9.95 KB | 18/02/2020 |
| ODBC SQL Examples | ODBC Examples.xlsm | 22 KB | 21/02/2020 |
| Force User to Enter a Value in a Cell before Closing or Saving a Workbook | Force Cell entry value before saving.xlsm | 14.3 KB | 22/02/2020 |
| Maintain a Rolling Window of different Time Series Data in a Master Table as a single line or combination Weekly | Rolling Time Series (Week Template).xlsb | 48.5 KB | 26/02/2020 |
| Maintain a Rolling Window of different Time Series Data in a Master Table as a single line or combination Monthly | Rolling Time Series (Month Template).xlsb | 45.8 KB | 26/02/2020 |
| Filter, Link & Align Excel Tables on Seperate Worksheets using Slicers or Autofilters | Filter Multiple Tables.xlsm | 112 KB | 07/03/2020 |
| Extracting Lists of Unique Items - In List Only Once | Unique List and In List Only Once.xlsx | 10.1 KB | 07/03/2020 |
| Bring back all Data in Other Columns for a Matching Item on a List | Bring back all Data in Other Columns for a Matching Item on a List.xlsx | 10.6 KB | 07/03/2020 |
| Zero Forecast Report for Demand Planning | Zero Forecast Report.xlsx | 66 KB | 17/12/2019 |
| Protect Worksheet via VBA including Cell Protection | Worksheet Protection via VBA.xlsm | 16.1 KB | 18/11/2020 |
| UI Styled Animated Checkbox List | UI Styled Animated Checkbox List.xlsm | 38.9 KB | 21/11/2020 |
| Month into Week (split volumes from a Month series into a Week series) | Month into Weeks Formula.xlsx | 46.3 KB | 13/03/2021 |
| Fix Chart Label Overlap (Center Series for 2 Series) | Fix Chart Label Overlap (Center Series).xlsm | 24.2 KB | 01/09/2021 |
| Fix Chart Label Overlap (Above & Below Series for 2 Series) | Fix Chart Label Overlap (Above & Below Series).xlsm | 25.2 KB | 01/09/2021 |
| Trial Dialog for Excel | Trial Dialog.xlsm | 31.7 KB | 14/09/2021 |
| Multi Drop-down List Lookup using Indirect for Excel | Multi Drop-down List Lookup.xlsx | 9.70 KB | 09/10/2021 |
| Outrageous Functions (Union Multiple Jagged Array Ranges in a Worksheet) | Outrageous Functions (Union).xlsm | 108 KB | 03/11/2021 |
| Outrageous Functions (Transmogrify Jagged Ranges - join in a mysterious way) | Outrageous Functions (Transmogrify).xlsm | 81.8 KB | 03/11/2021 |
| Merge Styles from one Workbook into another & Kill Styles | Blue BI Portal Report Style & Merge Styles Macro.xlsm | 13.7 KB | 13/11/2021 |
| converting multiple Rows of Weekly Data into Monthly Data (Daily Split Method) | Week into Month using Daily Split.xlsx | 2.96MB | 04/12/2021 |
| converting multiple Rows of Weekly Data into Monthly Data (Technical Periods Method) | Technical Periods (Week into Month).xlsx | 48.2KB | 04/12/2021 |
| converting a Single Row of Monthly Data into Weekly Data and Visa Versa | Month to Week & Visa Versa.xlsx | 21.9KB | 04/12/2021 |
| Count of Columns until the Cumulative Total or SUM is Greater than Some Value or Target for Example a Stock Weeks in Hand Calculation that Finds out How Many Weeks you have until the Forecast consumes all of your Stock (Stock Weeks in Hand) | Count of Rows and Columns to Exceed a Total SUM.xlsx | 12KB | 25/04/2022 |
| Stock Weeks in Hand Volatile Formula | Stock in Hand (Volatile Formula).xlsx | 18KB | 27/04/2022 |
| Stock Weeks in Hand Non-volatile Formula | Stock in Hand (Non-volatile Formula).xlsx | 18KB | 27/04/2022 |
| Copy Images with Transparency via the Clipboard into UserForm Controls | ImageTransparency.xlsm | 143KB | 30/12/2022 |
