{"id":13966,"date":"2021-12-14T05:40:23","date_gmt":"2021-12-14T05:40:23","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=13966"},"modified":"2021-12-14T05:41:14","modified_gmt":"2021-12-14T05:41:14","slug":"solved-vba-filter-multiple-criteria-options","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/vba-filter-multiple-criteria-options\/21655.html","title":{"rendered":"Solved VBA Filter Multiple Criteria Options"},"content":{"rendered":"<p>I need a VBA code to filter data based on the text found in column D. I want to add this macro to a button that moves me to a filtered sheet.<\/p>\n<p>I want the code to show 2 criteria. I do NOT want both criteria to be met, instead I want to show rows where either of the two criteria is met.<\/p>\n<p>Ex. Show rows with both &#8216;Example A&#8217; OR &#8216;Example B&#8217; in the 4th column. Hide every other row.<\/p>\n<p>Additionally, what VBA would I use to remove the filter after I activate a different sheet? The removal would have to show all data after and not leave the other rows hidden. Either when another sheet is activated, or when the filtered sheet is &#8220;deactivated&#8217; would work just fine.<\/p>\n<p>Thank you in advance for any assistance<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":0},"question-category":[53],"question_tags":[],"class_list":["post-13966","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/13966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=13966"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=13966"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=13966"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=13966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}