Creating list based on 3 criteria

You could use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

Hi,

Thats works perfectly - thanks.

How can I get this to work if I change the values in row B? For example all the A's are "Mouse", all the B's are "Cat" and all the C's are "Dog".

Thanks again.

You could try with this macro (you can put B values in any order and the match is not case sensitive):

Please Login or Register  to view this content.

Regards,
Antonio

Antonio,

Again, that works perfectly. I have thought of one final change, if you have any suggesions...?

Currently, the value in column A must have mouse, cat, and dog in column B before it is copied to Sheet2. It would be good if the column A figure figure went to Sheet2 if it only has mouse as well - as per the example attached.

This is the last change - honestly

Thanks so much.

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Antonio,

Thanks for your reply. Your code above brings through all entries that have a "Mouse" - even entries that have just "Mouse" and "Cat". What I'd like on Sheet2 is all entries that have "Mouse", "Cat" and "Dog", or just "Mouse" on its own.

Is that possible?

I apologize for the delay of my answer.

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Thats perfect. Thanks for your time and help