+ Reply to Thread
Results 1 to 2 of 2

How to record a macro that affects an autofilter based on 'boolean flag' cells?

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    Guildford, UK
    MS-Off Ver
    Excel 2003
    Posts
    23

    How to record a macro that affects an autofilter based on 'boolean flag' cells?

    Hi there.

    I'm new to autofiltering and writing VBA code so please be patient with me.

    I have 2 worksheets. The first worksheet contains a table, whilst the 2nd worksheet contains 'filter options' for that table.

    I want to be able to use some simple 'checkbox' style cells that have either a value of 0 or 1 so that when I run a macro, it will autofilter the table to include/disclude rows corresponding to those 'boolean cells' values.

    I have attached my workbook to show you what I mean.
    (In this workbook the 'Filter' worksheet has a number of green and red circles, which just amount to 1 or 0 values. I want to have a macro assigned to a button on the filter page which alters the table on the other page so that the table hides away any rows which contain the relevant Filter strings).

    Any help is much appreciated.

    Thanks

    Xander
    Attached Files Attached Files
    Last edited by xandermacleod; 05-08-2013 at 12:47 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How to record a macro that affects an autofilter based on 'boolean flag' cells?

    TaskTrack1 (1).xlsm

    How's that?.. I've only set it up to filter names but it shows the technique.
    Double click on the name traffic light symbols to toggle on/off and hit the filter button
    Elegant Simplicity............. Not Always

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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