On May 1, 5:31 pm, EdE wrote:
Also, is it possible to do this without writing a macro, as my knowledge of
VBA is fairly minimal and of UserForms is 0. If not, as I assume, that's OK,
I need to learn VBA and UserForms anyway.

Many MANY thanks in advance!

I'm not really sure what you're meaning, but it sounds like multiple
filters might avoid having to use VBA/Forms (but this depends on how
your data is organised). If your data looks like this, or can be
organised like this:

ColA ColB ColC ...
Spain Bob Apples
France Tom Pears
UK Mike Apples
Spain Mike Apples
UK Tom Pears
UK Bob Apples

(ie the filter criteria are all in separate columns).

highlight the whole table. Data....Filter...AutoFilter...
Then choose the criteria that you want
e.g. UK from ColA
Tom from ColB
etc..
The rows returned will be the rows which match all criteria.

HTH

Andrew