VBA AutoFilter

[Jack in the UK]

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

 

[Bruno_x]

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...

 

[Jack in the UK]

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

 

[Daniel Cremin]

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.

 

[Daniel Cremin]

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

 

[Jack in the UK]

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