Is it possible to create a macro which generates a new list based on a criteria list?

[NewbieNoob]

https://imgur.com/5GlXgm2

Assuming I have my list of cars in column A. I choose a certain type of cars in column C, would it then be possible to generate a list of the remaining cars in column E, which I did not choose?

I found something like this: http://www.excelfunctions.net/vba-filter-function.html I think Example 2 is what I exactly want, however I'm not sure how I assign this macro to a button to make it generate the list?

 

[Fluff]

That part of the code is removing the key from the dictionary & therefore you don't need to specify the item as that will automatically be removed

 

[NewbieNoob]

That part of the code is removing the key from the dictionary & therefore you don't need to specify the item as that will automatically be removed

That does make sense, thanks! My final question is regarding .Transpose at the end. Is the reason that we use this because keys are stored in one single row and in order to display them in a column, Transpose needs to be used?

 

[shg]

Right.