• Useful Excel Add-ins

    I try all of the add-ins I recommend, and won't recommend them unless I believe they are worthwhile (particularly if there is a charge!) Each of those listed below are helpful tools that I have no problem recommending.

    General Purpose Add-ins (Free)
    • ASAP Utilities
      • ASAP utilities is a standard install procedure for many advanced Excel users. Another addin full of great stuff!



    • Name Manager
      • Jan Karel's name Manager is an essential add-in for working with names.


    VBA Add-ins and Tools (Free)
    • MZ Tools
      • If you do any VBA developing, you need this addin. It is loaded with useful tools such as a code reviewer and much more to speed up your development process.



    • Smart Indenter
      • An awesome little add-in that makes indenting all of your code very simple. I find it really helps to know if you have an issue in a Case or If block, among other things.



    • PDF Creator
      • A free PDF writer utility that supports VBA.


    General Purpose Add-ins (Nominal Cost)

    Random Data Generator is an add-in for Microsoft® Excel 2003-2010 that lets you easily create fake, randomly generated personal and demographic information in Microsoft® Excel. No VBA skills required!

    This data can be used in applications such as PivotTables, macros, charts, tutorials, web demos, databases — anywhere that fake test data is needed, without using actual personal information (which may be protected by Sarbanes-Oxley [SOX] and/or the Health Insurance Portability and Accountability Act [HIPAA]).

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts

    Logit

    unduplicated list

    If you also include the "Check Run Date" column in the table as well, that will provide a means of selecting which month.

    Code:
    
    
    ...

    Logit Today, 04:35 PM Go to last post
    BuddyGSD

    unduplicated list

    Is there a way for excel to gather the names of the families from the month of April and May to appear on the Undup Clients tab then?...

    BuddyGSD Today, 04:08 PM Go to last post
    NoS

    Sum cells in each generated row

    Along with writing the form data to the sheet you could write a formula into the O column

    Code:
    Cells(whateverrow, 15).FormulaR1C1="=SUM(RC[-9]:RC[-1])"
    ...

    NoS Today, 02:27 PM Go to last post
    p45cal

    If overide formulae

    Array-enter (Ctrl+Shift+Enter, not just Enter) and copy down:
    =INDEX({"Fail";"Risk";"Pass"},MIN(MATCH(T2:U2,{"Fail","Risk","Pass"},0)))...

    p45cal Today, 12:14 PM Go to last post
    jonespandrew

    If overide formulae

    Sorry I have read you last response wrong Write

    Fail Risk would be a fail
    Risk pass would be a Risk
    Risk Fail would be a fail...

    jonespandrew Today, 11:14 AM Go to last post