Macro to apply and filter rows based on keywords

[exceleratevba]

Hi,

Looking for help with the following. I'd like to be able to run a macro that checks a column for specific keywords/phrases and then applies a filter to display just the rows with those keywords.


Sheet one has sample data that is copy/pasted into column A on the spreadsheet.

Sheet two shows the desired results and hides all the other data/rows except the ones that contain the specific keywords/phrases.

[jindon]

Use of AdvancedFilter

Please Login or Register  to view this content.

[exceleratevba]

I've copy/pasted the formula into my worksheet but I'm running into some issues.

X500371249104 00 0001 001 Problem with CDX UOM or qty
X500371252361 00 0001 002 Problem with CDX UOM or qty
X500371257580 00 0001 001 Health Canada Consmr Prod PGA data incomplete
X500371257580 00 0001 001 Problem with Tariff
X500371257580 00 0001 002 Problem with Tariff
X500371257775 00 0001 002 Health Canada Consmr Prod PGA data incomplete
X500371257775 00 0001 002 NRCan OEE data is not complete

There are a number of rows showing up that should be filtered out and a couple that should be displayed but are not showing up.

[jindon]

OOps
a4 should be a5

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.

[exceleratevba]

Thank you very much! That fixed the errors