Extract COS ITEMs only

[Howardc1001]

I have a sheet named "Imported Data"

I have set up a sheet "COS" to extract "COS" items only on this sheet which appear in Col K' on sheet "Imported Data" under the heading narrative

I have tried using Advanced Filter to do this but it also extracts Cost which I do not want

I have highlighted the items in Yellow that I want extracted on sheet "COS"


It would be appreciated if someone could kindly assist me

[alansidman]

Howard,
if you are willing to use Power Query then

Please Login or Register  to view this content.

[Howardc1001]

Hi Alan

Thanks for the help. The sample data only contained two categories in Col K containing OS but my actual data could have many categories that has "COS" in Col K

I think that VBA will be the best solution to extract only the items where there is test "COS" in the narrative in Col K

[sintek]

So simply...Or am I missing something...

Please Login or Register  to view this content.

[jindon]

my actual data could have many categories that has "COS" in Col K

List all the categories in Col.Q that you want to filter like attached.

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help Sintel & Jindon

Your code works perfectly

[alansidman]

Howard

another shot at PQ but only to expand your horizons.

Please Login or Register  to view this content.