• Sales Affiliate Program

    If you have a website or blog, or distribute newsletters by email, you can earn up to 30% in commissions by selling downloadable Excelguru products!

    All commissions are tracked by e-Junkie, the same vendor I use to sell all my products, and commissions are paid out on the 15th of the month following sale via PayPal. So what are you wating for? Join the Affiliate Program now!

    This page contains images and the html code you can use to place ads on your web pages. Replace AFFILIATE in the code below with your e-Junkie Affiliate ID and insert the code into the html code of your webpage, blog or email newsletter.

    These images are meant as a convenience to help you sell Excelguru products and earn a commission. If you would prefer to use your own images with these links, or insert links inline with text in your web pages, by all means, feel free. I'm fine with whatever you feel works best with your site.

    If you'd like to see banners of different shapes, sizes or styles,please let me know. I'll do my best to help!

    Banner Links

    The Magic of PivotTables - 728 x 90



    <a href="//www.e-junkie.com/ecom/gb.php?ii=1088604&c=ib&aff=AFFILIATE&cl=160142" target="ejejcsingle" title="XLG Magic of PivotTables"><img src="//www.excelguru.ca/images/xlgmopt728x90.gif" border="0"/></a>

    DIY BI Academy

    Excelguru has a new online learning platform for selling video courses. The DIY BI Academy is currently separate from the e-Junkie system, so if you would like to become an affiliate for these courses as well, please contact us for details. Below are some images you are welcome to use to help promote the courses:

    DIY BI Academy - 728 x 90

    DIY BI Academy - 300 x 250

    Adding Error Checking Course - 728 x 90


    Adding Error Checking Course - 300 x 250

     

    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