Hi thanks for the quick reply, I am not at all familiar with VBA unfortunately - part of my problem!

I was hoping for the ability to run the macro just by hitting enter - kind of imagine the same as google?

Allternatively, what would also be useful is one search box where I can enter multiple search criteria and run one macro to filter all the columns. Its really about ease and speed, aimed at people who are terrible at computers (even more than me)!