VBA AutoFilter
VBA AutoFilter
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: VBA AutoFilter

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi guys some assistance needed. ned to autofilter as many and also or as poss, but restricts to only 2 conditions. plan is to add extras as needed???

    Try this filter H <> PAID + <> NOT DUE + <> JACK will need to add more...

    Any ideas guys?

    Many thanks as always

    Jack in the UK

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  2. #2
    Board Regular Bruno's Avatar
    Join Date
    Feb 2002
    Posts
    480
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jack,
    Possible 'work around' :

    Use column I to check the values of column H

    =IF( AND(H1<>"PAID" ;H1<>"NOT DUE" ; H1<>"JACK"));1;0)

    and now you can use the autofilter in column I...


  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Cheers Bruno>>>

    Would prefer VBA so i can add conditions thou if poss, will for naw do as you say.

    VBA so can lock in module was the plan than hide / protect cells/columns/rows

    Any ideas guys??

    chers again

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why not use multiple Case-Select statements - narrow it down so that if it has Paid and NotDue (via a concatanated range of the twocells) then
    autofilter it out in vba.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    And any time you need to add a new type of condition just create a new concatenated cell range and make new case select statements

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi

    Thank so much for the reply FUNNY i was looking at a guys work, he / she knows its them if they read this and they have so gindly sent me some CASE work, DAM fine it is to and yes i agfree your guidence has pushed me to attack that avenue, so a big thanks.

    Many people see my posts i answer MANY questions, and must think why do i ask such mundain or bizzar questions, well its like this i use the reader/posters as ideas and if im honest i that EVERYONE who answers me as i have a basket of ideas to work from and so would be proud to thank everyone who answers and also thank so many who read my works and i hope i help if just one little bit. I get many mails and private post to the end... thank you all.

    Rdgs


    BTW i have a plan ill post sme case work as i have been asked this by a pal in trouble and many can use this, not perfect but will be my work a start point.

    Good luck all, Excel-ing
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com