+ Reply to Thread
Results 1 to 2 of 2

Helper Column Won't Filter

  1. #1
    Forum Contributor
    Join Date
    09-06-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    225

    Helper Column Won't Filter

    I have a macro that is supposed to take a sheet of data, add 2 helper columns, and then filter the entire dataset.

    The helper columns are added to the end of the data, with no problems.

    The problem is that when I use the filter method, it doesn't work for the new columns. After debugging and stepping through, it shows that all of the original columns have the filter dropdown showing, but the new helper columns do not have the dropdown showing. I'm thinking this is why they won't filter, but I dont know how to have them get a filter dropdown button like the rest of the columns. Is there something i need to do to make these added columns filter like the rest of the data? FYI- they are on the columns immediately following the original data set.

    Please assist.

    Thank you.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Helper Column Won't Filter

    Remove the filter and reinstall a new one with the complete range.
    Another way could be to add the 2 columns BEFORE the last column.
    For more help, send a sample of your data and a copy of the macro
    Last edited by PCI; 01-27-2014 at 04:50 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Helper Column IF Statement!
    By pwall1115 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2013, 12:41 AM
  2. Virtual Helper Column (Autofilter)
    By Chance2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2010, 04:07 AM
  3. help creating helper column
    By Allen Clark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2006, 12:20 AM
  4. [SOLVED] Changing the Helper Column
    By apples72 in forum Excel General
    Replies: 11
    Last Post: 11-13-2005, 06:22 PM
  5. [SOLVED] What is a helper column?
    By RMPPOD in forum Excel General
    Replies: 3
    Last Post: 01-28-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1