+ Reply to Thread
Results 1 to 7 of 7

collum to controll filter

  1. #1
    Registered User
    Join Date
    11-02-2012
    Location
    Lillehammer, Norway
    MS-Off Ver
    Excel 2007,2010
    Posts
    7

    collum to controll filter

    Hi

    I want a cell to controll the filter. Please look at the file.

    b1 controlls the filter.xlsx

    If I write "1" in the cell that should controll the filter, the filter should only show cells/rows that contains "1"
    Attached Images Attached Images
    Last edited by btlnorway; 11-02-2012 at 04:37 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: collum to controll filter

    you get better help if you add an exel-file without confidentional information.

    Please also add the desired result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    11-02-2012
    Location
    Lillehammer, Norway
    MS-Off Ver
    Excel 2007,2010
    Posts
    7

    Re: collum to controll filter

    Quote Originally Posted by oeldere View Post
    you get better help if you add an exel-file without confidentional information.

    Please also add the desired result.
    Edited first post :-)

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: collum to controll filter

    Try the attaced file.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    11-02-2012
    Location
    Lillehammer, Norway
    MS-Off Ver
    Excel 2007,2010
    Posts
    7

    Re: collum to controll filter

    This looks like visualbasic codes.
    well.. I only have the excel 2010 starter at home, but a licensed version at work.
    Will this work in a ordinary license version or do I have to buy a version that supports VB for excel?

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: collum to controll filter

    If you try it, you will know.

  7. #7
    Registered User
    Join Date
    11-02-2012
    Location
    Lillehammer, Norway
    MS-Off Ver
    Excel 2007,2010
    Posts
    7

    Re: collum to controll filter

    Back on work at monday :-)

+ 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