Error Checking in Excel
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,184
    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
    Location
    Flanders
    Posts
    484
    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,184
    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,184
    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"

Some videos you may like

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
  •