Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Custom filter
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Cimjet, post: 6458225"] Hi Everyone This macro does a custom filter on column B which are dates. I would like to have it done on all Tabs in the workbook and is it possible to have the two criteria "Start date and end date" variable with a popup menu This only works on one sheet. Sub Filter() For Each Worksheet In Workbooks Selection.AutoFilter Field:=2, Criteria1:=">4/1/2011", Operator:=xlAnd, _ Criteria2:="<4/30/2011" Next End Sub Regards Cimjet [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Custom filter
Top
