I regularly produce a large sheet of data with about 15 fields/columns and
several thousand rows on it which I currently filter by ones of the key
fields (which may contain up to 50 different values) and then run a macro on
each of those field selections (i.e. I manually run the same macro up to 50
times).

How can I automate the filter selection so I can cycle through the macro as
many times as required without any manual intervention.

Thanks,