VBA AutoFilter

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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...
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top