title: Excel to remove duplicates one column at a time for many columns
body: <p>I have an Excel workbook with many sheets(40+) which have many columns in each(30+).</p>
  
  <p>My goal is to remove duplicates in each column but not based on any other columns. I would like to repeat this for all columns in all sheets.</p>
  
  <p>I tried to create a macro but upon execution the macro will only select the column that I had selected when I created the macro.</p>