• Add-ins & Tools

    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.

    In the interests of full disclosure here, any images below contains an affiliate link, so I do make a (small) amount of money if you click through and purchase. If you find that offensive, you can always go directly to the site in question and purchase direct.

    Chandoo's Excel Templates
    Chandoo is a fellow Excel MVP with a passion for dashboarding and Excel. He has Excel Templates for sale, as well as runs an online Excel School which includes Dashboard Training.


    Peltier Tech Charting Utilities for Excel
    Jon Peltier has a wide variety of tools for easily building complicated Excel charts. I'd highly recommend checking them out.


    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.

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

     

    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

    Bob Phillips

    VBA Programming help

    Code:
    Public Sub KeepHighest()
    Dim lastrow As Long
    Dim i As Long
        
        Application.ScreenUpdating = False
        With ActiveSheet
    ...

    Bob Phillips Today, 10:56 AM Go to last post
    Shoeboxken

    VBA Programming help

    I would like to use a VBA coding to create a list of information pulled from a data set.

    Data would include the following info as examples:...

    Shoeboxken Today, 05:36 AM Go to last post
    facams

    delete duplicate entries

    Thank you sir will try it...

    facams Yesterday, 09:00 PM Go to last post
    Bob Phillips

    delete duplicate entries

    Code:
    Public Sub DeleteDuplicates()
    Dim lastrow As Long
    Dim i As Long
        Application.ScreenUpdating = False
        
        With ActiveSheet
    ...

    Bob Phillips Yesterday, 08:25 PM Go to last post
    facams

    delete duplicate entries

    HI, new here. I need help in deleting duplicate cells that have same name or account # then based on an action that states "report" even if...

    facams Yesterday, 07:57 PM Go to last post