excel-helpers

Excel tools and VBA snippets for focused business tasks

• See Project wiki for details.
• Click here to download the latest release.
• Create New Issue to share new ideas, report bug, etc.

How to install the tools:

1. Download Zip-file with the latest release.
   
2. Extract Zip-file to any folder you wish.
   
3. Open subfolder with the tool you need and open the tool file.
   
4. Read the manual on 'HowTo' sheet.
   
5. Use the tool.
   

Coming soon:

• VBA scenario analysis tools that simplify your everyday analysis in Excel. Tool #1 works like What-If analysis, but with more than 2 parameters at once. Tool #2 is a wrapper for the Solver add-in, which allows you to work with it easier and faster, without changing parameter cell values, and keep your results in an easy-to-use table for future analysis, i.e. using Tool #1;)

Done:

• Histogram maker tool - Instrument for playing with data ranges to create nice-looking histogram charts.
• Decision making tool - Tool for making decisions based on experts opinions.
• Dynamic GANTT tool - Lightweight tool for creating autoupdated GANTT charts based on cells values.
• Agenda builder tool - Tool for creating and updating agendas for importaint events (incl. multidays events).
• Multivalue cells macro - You can keep few values in one cell using special form.
• Friendly spam sender tool - Instrument to send personalized template-based emails to the list of recipients.
• VBA XML Comments to Github wiki pages tool - Tool for generating Github markdown wiki-pages from VBA modules which contain XML comments.
• Update table records tool - Instrument for joining data from different files (i.e. The table contains information about KPIs from different subsidiaries. You are sending this table to subsidiaries for filling their respective parts and then preparing joint answer for your management).
• Snippets v1.0 40 functions in 7 files - VBA snippets which help to develop your personal VBA-tools.
• VBA OmniLogger Framework - logging events and/or errors from your VBA-code into txt/csv files, Excel range or VBA Immediate window.
• VBA Profiler - monitoring of VBA code productivity with reporting to txt/csv files, Excel range, VBA Immediate window or JSON file.