Filtering based on selection

[jdmc45]

Hi,

I have a long list with three long columns, column A is Code, column B is Date, Column C is Price.

I also have a much smaller list of the codes, 20 or so, which I want to filter the first list on. So for the list with three columns, I only want the entries that have the code in this smaller list.

What is the quickest way to do this? Currently I am filtering manually and it's taking ages.

Thanks for your help

 

[Weaver]

Have you spotted the 'advanced filter' option? Have a read of how that works, you might be pleasantly surprised.

 

[jdmc45]

Have you spotted the 'advanced filter' option? Have a read of how that works, you might be pleasantly surprised.

I have looked into it, it is cumbersome and very slow. I want to be able to do it very quickly, as I have hundreds of worksheets to get through.

 

[Weaver]

What you could do is use it once while recording a macro, then use the code generated to process the other sheets. You may need to edit to make it more generic - post back if you need help with this part of the process.